/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : zcwg

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 01/12/2020 11:57:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for jsh_account
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account`;
CREATE TABLE `jsh_account` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `serial_no` varchar(50) DEFAULT NULL COMMENT '编号',
  `initial_amount` decimal(24,6) DEFAULT NULL COMMENT '期初金额',
  `current_amount` decimal(24,6) DEFAULT NULL COMMENT '当前余额',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `is_default` bit(1) DEFAULT NULL COMMENT '是否默认',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='账户信息';

-- ----------------------------
-- Records of jsh_account
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account` VALUES (17, '账户1', 'zzz111', 100.000000, -2096.000000, 'aabb', b'1', 63, '0');
INSERT INTO `jsh_account` VALUES (18, '账户2', '1234131324', 200.000000, -1750.000000, 'bb', b'0', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_account_head
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account_head`;
CREATE TABLE `jsh_account_head` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(支出/收入/收款/付款/转账)',
  `organ_id` bigint(20) DEFAULT NULL COMMENT '单位Id(收款/付款单位)',
  `hands_person_id` bigint(20) DEFAULT NULL COMMENT '经手人id',
  `creator` bigint(20) DEFAULT NULL COMMENT '操作员',
  `change_amount` decimal(24,6) DEFAULT NULL COMMENT '变动金额(优惠/收款/付款/实付)',
  `total_price` decimal(24,6) DEFAULT NULL COMMENT '合计金额',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户(收款/付款)',
  `bill_no` varchar(50) DEFAULT NULL COMMENT '单据编号',
  `bill_time` datetime DEFAULT NULL COMMENT '单据日期',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK9F4C0D8DB610FC06` (`organ_id`),
  KEY `FK9F4C0D8DAAE50527` (`account_id`),
  KEY `FK9F4C0D8DC4170B37` (`hands_person_id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT='财务主表';

-- ----------------------------
-- Records of jsh_account_head
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account_head` VALUES (97, '收入', 58, 16, 63, 10.000000, 10.000000, 17, 'SR20191228121609', '2019-12-28 00:00:00', '备注1', 63, '0');
INSERT INTO `jsh_account_head` VALUES (98, '支出', 57, 16, 63, -20.000000, -20.000000, 17, 'ZC20191228121854', '2019-12-28 12:18:54', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (99, '收款', 58, 16, 63, NULL, 20.000000, NULL, 'SK20191228121908', '2019-12-28 12:19:08', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (100, '付款', 68, 16, 63, NULL, -20.000000, NULL, 'FK20191228121920', '2019-12-28 12:19:20', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (101, '转账', NULL, 16, 63, -20.000000, -20.000000, 18, 'ZZ20191228121932', '2019-12-28 12:19:32', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (102, '收预付款', 60, 16, 63, NULL, 1000.000000, NULL, 'SYF20191228121945', '2019-12-28 12:19:45', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (103, '收入', 58, 16, 63, 20.000000, 20.000000, 18, 'SR20200721163125', '2020-07-21 16:31:25', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (104, '收入', 71, 16, 63, 60.000000, 50.000000, 18, 'SR20200721225712', '2020-07-21 00:00:00', 'bb', 63, '0');
INSERT INTO `jsh_account_head` VALUES (105, '转账', NULL, 16, 63, -11.000000, -11.000000, 18, 'ZZ20200722005429', '2020-07-22 00:54:29', '', 63, '0');
INSERT INTO `jsh_account_head` VALUES (106, '收入', 58, 16, 131, 1000.000000, 1000.000000, 17, 'SR20200913184412', '2020-09-13 11:00:00', '', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_account_item
-- ----------------------------
DROP TABLE IF EXISTS `jsh_account_item`;
CREATE TABLE `jsh_account_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `header_id` bigint(20) NOT NULL COMMENT '表头Id',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户Id',
  `in_out_item_id` bigint(20) DEFAULT NULL COMMENT '收支项目Id',
  `each_amount` decimal(24,6) DEFAULT NULL COMMENT '单项金额',
  `remark` varchar(100) DEFAULT NULL COMMENT '单据备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK9F4CBAC0AAE50527` (`account_id`),
  KEY `FK9F4CBAC0C5FE6007` (`header_id`),
  KEY `FK9F4CBAC0D203EDC5` (`in_out_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='财务子表';

-- ----------------------------
-- Records of jsh_account_item
-- ----------------------------
BEGIN;
INSERT INTO `jsh_account_item` VALUES (98, 97, NULL, 22, 10.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (99, 98, NULL, 21, 20.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (100, 99, 17, NULL, 20.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (101, 100, 17, NULL, -20.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (102, 101, 17, NULL, 20.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (103, 102, 17, NULL, 1000.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (104, 103, NULL, 22, 20.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (105, 104, NULL, 22, 50.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (106, 105, 17, NULL, 11.000000, '', 63, '0');
INSERT INTO `jsh_account_item` VALUES (107, 106, NULL, 22, 1000.000000, '', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_depot
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot`;
CREATE TABLE `jsh_depot` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(20) DEFAULT NULL COMMENT '仓库名称',
  `address` varchar(50) DEFAULT NULL COMMENT '仓库地址',
  `warehousing` decimal(24,6) DEFAULT NULL COMMENT '仓储费',
  `truckage` decimal(24,6) DEFAULT NULL COMMENT '搬运费',
  `type` int(10) DEFAULT NULL COMMENT '类型',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `remark` varchar(100) DEFAULT NULL COMMENT '描述',
  `principal` bigint(20) DEFAULT NULL COMMENT '负责人',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `is_default` bit(1) DEFAULT NULL COMMENT '是否默认',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
-- Records of jsh_depot
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot` VALUES (14, '太仓中材三号仓库', '太仓市沙溪镇二环路', 3000.000000, 3000.000000, 0, '1', '描述', 63, 63, '0', b'1');
INSERT INTO `jsh_depot` VALUES (15, '太仓中材一号仓库', '太仓市双凤镇吴中路', 20.000000, 3000.000000, 0, '1', '', 132, 63, '0', b'0');
INSERT INTO `jsh_depot` VALUES (17, '太仓中材二号仓库', '苏州吴中区玉山路12号', 300.000000, 3000.000000, 0, '123', '123', 63, 63, '0', b'0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_depot_head
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot_head`;
CREATE TABLE `jsh_depot_head` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(出库/入库)',
  `sub_type` varchar(50) DEFAULT NULL COMMENT '出入库分类',
  `default_number` varchar(50) DEFAULT NULL COMMENT '初始票据号',
  `number` varchar(50) DEFAULT NULL COMMENT '票据号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `oper_time` datetime DEFAULT NULL COMMENT '出入库时间',
  `organ_id` bigint(20) DEFAULT NULL COMMENT '供应商id',
  `hands_person_id` bigint(20) DEFAULT NULL COMMENT '采购/领料-经手人id',
  `creator` bigint(20) DEFAULT NULL COMMENT '操作员',
  `account_id` bigint(20) DEFAULT NULL COMMENT '账户id',
  `change_amount` decimal(24,6) DEFAULT NULL COMMENT '变动金额(收款/付款)',
  `total_price` decimal(24,6) DEFAULT NULL COMMENT '合计金额',
  `pay_type` varchar(50) DEFAULT NULL COMMENT '付款类型(现金、记账等)',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `sales_man` varchar(50) DEFAULT NULL COMMENT '业务员（可以多个）',
  `account_id_list` varchar(50) DEFAULT NULL COMMENT '多账户ID列表',
  `account_money_list` varchar(200) DEFAULT NULL COMMENT '多账户金额列表',
  `discount` decimal(24,6) DEFAULT NULL COMMENT '优惠率',
  `discount_money` decimal(24,6) DEFAULT NULL COMMENT '优惠金额',
  `discount_last_money` decimal(24,6) DEFAULT NULL COMMENT '优惠后金额',
  `other_money` decimal(24,6) DEFAULT NULL COMMENT '销售或采购费用合计',
  `other_money_list` varchar(200) DEFAULT NULL COMMENT '销售或采购费用涉及项目Id数组（包括快递、招待等）',
  `other_money_item` varchar(200) DEFAULT NULL COMMENT '销售或采购费用涉及项目（包括快递、招待等）',
  `account_day` int(10) DEFAULT NULL COMMENT '结算天数',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，0未审核、1已审核、2已转采购|销售',
  `link_number` varchar(50) DEFAULT NULL COMMENT '关联订单号',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK2A80F214C4170B37` (`hands_person_id`),
  KEY `FK2A80F214B610FC06` (`organ_id`),
  KEY `FK2A80F214AAE50527` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8 COMMENT='单据主表';

-- ----------------------------
-- Records of jsh_depot_head
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot_head` VALUES (189, '入库', '采购', 'CGRK00000000261', 'CGRK00000000261', '2019-04-10 22:25:49', '2020-02-20 23:51:03', 57, NULL, NULL, 17, -120.000000, -120.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 120.000000, 0.000000, '[\"undefined\"]', '[\"undefined\"]', NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (191, '入库', '采购', 'CGRK00000000264', 'CGRK00000000264', '2019-04-13 19:57:58', '2020-02-20 23:50:55', 57, NULL, NULL, 17, -10.000000, -10.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 10.000000, 0.000000, '[\"undefined\"]', '[\"undefined\"]', NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (192, '入库', '采购', 'CGRK00000000265', 'CGRK00000000265', '2019-04-20 00:36:24', '2020-02-20 23:50:47', 57, NULL, NULL, 17, -220.000000, -220.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 220.000000, 0.000000, '[\"undefined\"]', '[\"undefined\"]', NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (193, '出库', '销售', 'XSCK00000000268', 'XSCK00000000268', '2019-04-29 23:41:02', '2020-02-20 23:52:17', 58, NULL, NULL, 17, 300.000000, 300.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 300.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (196, '入库', '采购', 'CGRK00000000274', 'CGRK00000000274', '2019-04-30 22:35:53', '2020-02-20 23:49:07', 57, NULL, NULL, 18, -1930.000000, -1930.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 1930.000000, 0.000000, '[\"undefined\"]', '[\"undefined\"]', NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (197, '出库', '销售', 'XSCK00000000290', 'XSCK00000000290', '2019-04-30 23:15:27', '2020-02-20 23:52:01', 58, NULL, NULL, 17, 270.000000, 270.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 270.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (199, '其它', '采购订单', 'CGDD00000000305', 'CGDD00000000305', '2019-12-28 12:16:36', '2020-02-20 23:47:56', 57, 63, 63, NULL, 0.000000, -22.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (200, '出库', '采购退货', 'CGTH00000000306', 'CGTH00000000306', '2019-12-28 12:16:55', '2020-02-20 23:51:28', 57, 63, 63, 17, 11.000000, 11.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 11.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (201, '其它', '销售订单', 'XSDD00000000307', 'XSDD00000000307', '2019-12-28 12:17:09', '2020-02-20 23:51:37', 58, 63, 63, NULL, 0.000000, 15.000000, '现付', '', '<14>', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (202, '入库', '销售退货', 'XSTH00000000308', 'XSTH00000000308', '2019-12-28 12:17:22', '2020-02-20 23:52:33', 58, 63, 63, 17, -15.000000, -15.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 15.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (203, '入库', '其它', 'QTRK00000000309', 'QTRK00000000309', '2019-12-28 12:17:40', '2020-02-20 23:52:51', 57, 63, 63, NULL, 0.000000, 42.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (204, '出库', '其它', 'QTCK00000000310', 'QTCK00000000310', '2019-12-28 12:17:48', '2020-02-20 23:53:04', 58, 63, 63, NULL, 0.000000, 15.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (205, '出库', '调拨', 'DBCK00000000311', 'DBCK00000000311', '2019-12-28 12:17:58', '2020-02-20 23:53:21', NULL, 63, 63, NULL, 0.000000, 15.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (206, '其它', '组装单', 'ZZD00000000312', 'ZZD00000000312', '2019-12-28 12:18:09', '2020-02-20 23:54:02', NULL, 63, 63, NULL, 0.000000, 10.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (207, '其它', '拆卸单', 'CXD00000000313', 'CXD00000000313', '2019-12-28 12:18:47', '2020-02-20 23:54:21', NULL, 63, 63, NULL, 0.000000, 0.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (208, '出库', '零售', 'LSCK00000000314', 'LSCK00000000314', '2019-12-28 12:20:26', '2019-12-28 12:20:14', 60, 63, 63, 17, 30.000000, 30.000000, '预付款', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (209, '入库', '零售退货', 'LSTH00000000315', 'LSTH00000000315', '2019-12-28 12:20:39', '2019-12-28 12:20:29', 60, 63, 63, 17, -15.000000, -15.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (210, '入库', '采购', 'CGRK00000000318', 'CGRK00000000318', '2020-02-20 23:22:38', '2020-02-20 23:22:27', 57, 63, 63, 17, -110.000000, -110.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (211, '入库', '采购', 'CGRK00000000319', 'CGRK00000000319', '2020-02-20 23:54:48', '2020-02-20 23:54:33', 57, 63, 63, 17, -2400.000000, -2400.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 2400.000000, NULL, '[\"undefined\"]', '[\"undefined\"]', NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (212, '入库', '采购', 'CGRK00000000320', 'CGRK00000000320', '2020-07-14 00:28:15', '2020-07-14 00:27:59', 57, 63, 63, 17, -535.000000, -535.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 535.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (214, '出库', '销售', 'XSCK00000000321', 'XSCK00000000321', '2020-07-15 00:38:07', '2020-07-15 00:37:36', 58, 63, 63, 17, 2400.000000, 2500.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 2500.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (215, '入库', '采购', 'CGRK00000000329', 'CGRK00000000329', '2020-07-21 00:35:16', '2020-07-21 00:35:05', 57, 63, 63, 17, -800.000000, -800.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 800.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (216, '出库', '销售', 'XSCK00000000330', 'XSCK00000000330', '2020-07-21 00:35:37', '2020-07-21 00:35:26', 58, 63, 63, 17, 308.000000, 308.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 308.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (217, '其它', '采购订单', 'CGDD00000000333', 'CGDD00000000333', '2020-07-21 01:15:15', '2020-07-21 01:15:07', 57, 63, 63, NULL, 0.000000, -96.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (218, '入库', '采购', 'CGRK00000000334', 'CGRK00000000334', '2020-07-21 01:15:32', '2020-07-21 01:15:28', 57, 63, 63, 17, -270.000000, -270.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 270.000000, NULL, NULL, NULL, NULL, '0', 'CGDD00000000333', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (219, '出库', '销售', 'XSCK00000000336', 'XSCK00000000336', '2020-07-21 15:06:02', '2020-07-21 15:05:49', 59, 63, 63, 17, 70.000000, 70.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 70.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (222, '出库', '销售', 'XSCK00000000338', 'XSCK00000000338', '2020-07-21 23:05:55', '2020-07-21 23:04:05', 58, 63, 63, 17, 110.000000, 110.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (223, '入库', '采购', 'CGRK00000000339', 'CGRK00000000339', '2020-07-21 23:06:55', '2020-07-21 23:06:43', 68, 63, 63, 17, -110.000000, -110.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (224, '出库', '销售', 'XSCK00000000340', 'XSCK00000000340', '2020-07-21 23:07:06', '2020-07-21 23:06:59', 71, 63, 63, 17, 44.000000, 44.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 44.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (225, '其它', '盘点录入', 'PDLR00000000342', 'PDLR00000000342', '2020-07-22 00:07:13', '2020-07-22 00:06:53', NULL, 63, 63, NULL, 0.000000, 16.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (226, '其它', '盘点复盘', 'PDFP00000000344', 'PDFP00000000344', '2020-07-22 00:07:41', '2020-07-22 00:08:06', NULL, 63, 63, NULL, 0.000000, 16.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', 'PDFP00000000343', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (227, '其它', '采购订单', 'CGDD00000000345', 'CGDD00000000345', '2020-07-22 00:41:37', '2020-07-22 00:41:27', 74, 63, 63, NULL, 0.000000, -110.000000, '现付', '', '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (228, '入库', '采购', 'CGRK00000000351', 'CGRK00000000351', '2020-07-22 00:48:09', '2020-07-22 00:47:48', 74, 63, 63, 17, -110.000000, -110.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, '0', 'CGDD00000000345', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (229, '入库', '采购', 'CGRK00000000352', 'CGRK00000000352', '2020-09-13 18:43:56', '2020-09-13 18:43:45', 57, NULL, 131, 17, -90.000000, -90.000000, '现付', '', '', NULL, '', 0.000000, 0.000000, 90.000000, NULL, NULL, NULL, NULL, '0', '', 63, '0');
INSERT INTO `jsh_depot_head` VALUES (230, '其它', '销售订单', 'XSDD00000000405', 'XSDD00000000405', '2020-11-05 19:54:42', '2020-11-05 19:46:20', 58, NULL, 63, NULL, 0.000000, 22.000000, '现付', '', '<14>', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_depot_item
-- ----------------------------
DROP TABLE IF EXISTS `jsh_depot_item`;
CREATE TABLE `jsh_depot_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `header_id` bigint(20) NOT NULL COMMENT '表头Id',
  `material_id` bigint(20) NOT NULL COMMENT '商品Id',
  `material_extend_id` bigint(20) DEFAULT NULL COMMENT '商品扩展id',
  `material_unit` varchar(20) DEFAULT NULL COMMENT '商品计量单位',
  `oper_number` decimal(24,6) DEFAULT NULL COMMENT '数量',
  `basic_number` decimal(24,6) DEFAULT NULL COMMENT '基础数量，如kg、瓶',
  `unit_price` decimal(24,6) DEFAULT NULL COMMENT '单价',
  `tax_unit_price` decimal(24,6) DEFAULT NULL COMMENT '含税单价',
  `all_price` decimal(24,6) DEFAULT NULL COMMENT '金额',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `img` varchar(50) DEFAULT NULL COMMENT '图片',
  `incidentals` decimal(24,6) DEFAULT NULL COMMENT '运杂费',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库ID',
  `another_depot_id` bigint(20) DEFAULT NULL COMMENT '调拨时，对方仓库Id',
  `tax_rate` decimal(24,6) DEFAULT NULL COMMENT '税率',
  `tax_money` decimal(24,6) DEFAULT NULL COMMENT '税额',
  `tax_last_money` decimal(24,6) DEFAULT NULL COMMENT '价税合计',
  `other_field1` varchar(50) DEFAULT NULL COMMENT '自定义字段1-名称',
  `other_field2` varchar(50) DEFAULT NULL COMMENT '自定义字段2-型号',
  `other_field3` varchar(50) DEFAULT NULL COMMENT '自定义字段3-制造商',
  `other_field4` varchar(50) DEFAULT NULL COMMENT '自定义字段4-名称',
  `other_field5` varchar(50) DEFAULT NULL COMMENT '自定义字段5-名称',
  `material_type` varchar(20) DEFAULT NULL COMMENT '商品类型',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK2A819F475D61CCF7` (`material_id`),
  KEY `FK2A819F474BB6190E` (`header_id`),
  KEY `FK2A819F479485B3F5` (`depot_id`),
  KEY `FK2A819F47729F5392` (`another_depot_id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=utf8 COMMENT='单据子表';

-- ----------------------------
-- Records of jsh_depot_item
-- ----------------------------
BEGIN;
INSERT INTO `jsh_depot_item` VALUES (198, 189, 569, 3, '只', 12.000000, 12.000000, 10.000000, 10.000000, 120.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 120.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (200, 191, 569, 3, '只', 1.000000, 1.000000, 10.000000, 10.000000, 10.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 10.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (201, 192, 569, 3, '只', 22.000000, 22.000000, 10.000000, 10.000000, 220.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 220.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (202, 193, 569, 3, '只', 20.000000, 0.000000, 15.000000, 15.000000, 300.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 300.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (205, 196, 569, 3, '只', 2.000000, 122.000000, 10.000000, 10.000000, 20.000000, '', NULL, NULL, 15, NULL, 0.000000, 0.000000, 20.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (206, 197, 569, 3, '只', 18.000000, 0.000000, 15.000000, 15.000000, 270.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 270.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (207, 196, 568, 2, '个', 10.000000, 2.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 15, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (208, 196, 568, 2, '个', 10.000000, 2.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 15, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (209, 196, 568, 2, '个', 10.000000, 2.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (210, 196, 568, 2, '个', 10.000000, 2.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (211, 196, 568, 2, '个', 10.000000, 3.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (212, 196, 568, 2, '个', 10.000000, 4.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (213, 196, 568, 2, '个', 100.000000, 5.000000, 11.000000, 11.000000, 1100.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 1100.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (214, 196, 569, 3, '只', 15.000000, 6.000000, 10.000000, 10.000000, 150.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 150.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (216, 199, 568, 2, '个', 2.000000, 2.000000, 11.000000, 11.000000, 22.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 22.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (217, 200, 568, 2, '个', 1.000000, 0.000000, 11.000000, 11.000000, 11.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 11.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (218, 201, 568, 2, '个', 1.000000, 1.000000, 15.000000, 15.000000, 15.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 15.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (219, 202, 568, 2, '个', 1.000000, 1.000000, 15.000000, 15.000000, 15.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 15.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (220, 203, 568, 2, '个', 2.000000, 2.000000, 11.000000, 11.000000, 22.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 22.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (221, 203, 569, 3, '只', 2.000000, 2.000000, 10.000000, 10.000000, 20.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 20.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (222, 204, 569, 3, '只', 1.000000, 0.000000, 15.000000, 15.000000, 15.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 15.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (223, 205, 568, 2, '个', 1.000000, 1.000000, 15.000000, 15.000000, 15.000000, '', NULL, NULL, 14, 15, 0.000000, 0.000000, 15.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (224, 206, 568, 2, '个', 1.000000, 1.000000, 5.000000, 5.000000, 5.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 5.000000, '', '', '', '', '', '组合件', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (225, 206, 569, 3, '只', 1.000000, 1.000000, 5.000000, 5.000000, 5.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 5.000000, '', '', '', '', '', '普通子件', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (226, 207, 569, 3, '只', 1.000000, 1.000000, 0.000000, 0.000000, 0.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 0.000000, '', '', '', '', '', '组合件', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (227, 207, 568, 2, '个', 1.000000, 1.000000, 0.000000, 0.000000, 0.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 0.000000, '', '', '', '', '', '普通子件', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (228, 208, 568, 2, '个', 2.000000, 2.000000, 15.000000, 15.000000, 30.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 30.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (229, 209, 568, 2, '个', 1.000000, 1.000000, 15.000000, 15.000000, 15.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 15.000000, '', '', '', '', '', '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (230, 210, 587, 1, '个', 10.000000, 10.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (231, 211, 579, 8, '箱', 10.000000, 120.000000, 240.000000, 240.000000, 2400.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 2400.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (232, 212, 587, 1, '个', 5.000000, 5.000000, 11.000000, 11.000000, 55.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 55.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (233, 212, 570, 4, '个', 60.000000, 60.000000, 8.000000, 8.000000, 480.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 480.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (234, 214, 570, 4, '个', 100.000000, 100.000000, 14.000000, 14.000000, 1400.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 1400.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (235, 214, 587, 1, '个', 50.000000, 50.000000, 22.000000, 22.000000, 1100.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 1100.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (236, 215, 570, 4, '个', 100.000000, 100.000000, 8.000000, 8.000000, 800.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 800.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (237, 216, 570, 4, '个', 22.000000, 22.000000, 14.000000, 14.000000, 308.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 308.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (238, 217, 570, 4, '个', 12.000000, 12.000000, 8.000000, 8.000000, 96.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 96.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (239, 218, 570, 4, '个', 15.000000, 15.000000, 18.000000, 18.000000, 270.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 270.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (240, 219, 570, 4, '个', 5.000000, 5.000000, 14.000000, 14.000000, 70.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 70.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (241, 222, 588, 10, '个', 5.000000, 5.000000, 22.000000, 22.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (242, 223, 588, 10, '个', 10.000000, 10.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (243, 224, 588, 10, '个', 2.000000, 2.000000, 22.000000, 22.000000, 44.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 44.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (244, 225, 570, 4, '个', 2.000000, 2.000000, 8.000000, 8.000000, 16.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 16.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (245, 226, 570, 4, '个', 2.000000, 2.000000, 8.000000, 8.000000, 16.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 16.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (246, 227, 588, 10, '个', 10.000000, 10.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (247, 228, 588, 10, '个', 10.000000, 10.000000, 11.000000, 11.000000, 110.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 110.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (248, 229, 569, 3, '只', 9.000000, 9.000000, 10.000000, 10.000000, 90.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 90.000000, NULL, NULL, NULL, NULL, NULL, '', 63, '0');
INSERT INTO `jsh_depot_item` VALUES (249, 230, 588, 10, '个', 1.000000, 1.000000, 22.000000, 22.000000, 22.000000, '', NULL, NULL, 14, NULL, 0.000000, 0.000000, 22.000000, NULL, NULL, NULL, NULL, NULL, NULL, 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_function
-- ----------------------------
DROP TABLE IF EXISTS `jsh_function`;
CREATE TABLE `jsh_function` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `number` varchar(50) DEFAULT NULL COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `parent_number` varchar(50) DEFAULT NULL COMMENT '上级编号',
  `url` varchar(100) DEFAULT NULL COMMENT '链接',
  `state` bit(1) DEFAULT NULL COMMENT '收缩',
  `sort` varchar(50) DEFAULT NULL COMMENT '排序',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `push_btn` varchar(50) DEFAULT NULL COMMENT '功能按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8 COMMENT='功能模块表';

-- ----------------------------
-- Records of jsh_function
-- ----------------------------
BEGIN;
INSERT INTO `jsh_function` VALUES (1, '0001', '系统管理', '0', '', b'1', '0910', b'1', '电脑版', '', 'icon-settings', '0');
INSERT INTO `jsh_function` VALUES (13, '000102', '角色管理', '0001', '/pages/manage/role.html', b'0', '0130', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (14, '000103', '用户管理', '0001', '/pages/manage/user.html', b'0', '0140', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (15, '000104', '日志管理', '0001', '/pages/manage/log.html', b'0', '0160', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (16, '000105', '功能管理', '0001', '/pages/manage/functions.html', b'0', '0166', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (21, '0101', '产品管理', '0', '', b'0', '0620', b'1', '电脑版', '', 'icon-social-dropbox', '0');
INSERT INTO `jsh_function` VALUES (22, '010101', '成品类别', '0101', '/pages/materials/materialcategory.html', b'0', '0230', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (23, '010102', '成品信息', '0101', '/pages/materials/material.html', b'0', '0240', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (24, '0102', '基本资料', '0', '', b'0', '0750', b'1', '电脑版', NULL, 'icon-grid', '0');
INSERT INTO `jsh_function` VALUES (25, '01020101', '供应商信息', '0102', '/pages/manage/vendor.html', b'0', '0260', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (26, '010202', '仓库信息', '0102', '/pages/manage/depot.html', b'0', '0270', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (31, '010206', '经手人管理', '0102', '/pages/manage/person.html', b'0', '0284', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (32, '0502', '采购管理', '0', '', b'0', '0330', b'1', '电脑版', '', 'icon-loop', '0');
INSERT INTO `jsh_function` VALUES (33, '050201', '采购入库', '0502', '/pages/bill/purchase_in_list.html', b'0', '0340', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (38, '0603', '订单管理', '0', '', b'0', '0390', b'1', '电脑版', '', 'icon-briefcase', '0');
INSERT INTO `jsh_function` VALUES (40, '080107', '已出库', '0801', '/pages/bill/allocation_out_list.html', b'0', '0807', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (41, '060303', '生产订单', '0603', '/pages/manage/scorder.html', b'0', '0394', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (44, '0704', '财务管理', '0', '', b'0', '0470', b'1', '电脑版', '', 'icon-map', '0');
INSERT INTO `jsh_function` VALUES (59, '030101', '库存状况', '0301', '/pages/reports/in_out_stock_report.html', b'0', '0600', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (194, '010204', '收支项目', '0102', '/pages/manage/inOutItem.html', b'0', '0282', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (195, '010205', '结算账户', '0102', '/pages/manage/account.html', b'0', '0283', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (197, '070402', '收入单', '0704', '/pages/financial/item_in.html', b'0', '0465', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (198, '0301', '报表查询', '0', '', b'0', '0570', b'1', '电脑版', NULL, 'icon-pie-chart', '0');
INSERT INTO `jsh_function` VALUES (199, '050204', '采购退货', '0502', '/pages/bill/purchase_back_list.html', b'0', '0345', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (200, '060305', '退货订单', '0603', '/pages/bill/sale_back_list.html', b'0', '0396', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (201, '080103', '库存管理', '0801', '/pages/bill/other_in_list.html', b'0', '0803', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (202, '080105', '待出库', '0801', '/pages/bill/other_out_list.html', b'0', '0805', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (203, '070403', '支出单', '0704', '/pages/financial/item_out.html', b'0', '0470', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (204, '070404', '收款单', '0704', '/pages/financial/money_in.html', b'0', '0475', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (205, '070405', '付款单', '0704', '/pages/financial/money_out.html', b'0', '0480', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (206, '070406', '转账单', '0704', '/pages/financial/giro.html', b'0', '0490', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (207, '030102', '账户统计', '0301', '/pages/reports/account_report.html', b'0', '0610', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (208, '030103', '进货统计', '0301', '/pages/reports/buy_in_report.html', b'0', '0620', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (209, '030104', '销售统计', '0301', '/pages/reports/sale_out_report.html', b'0', '0630', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (210, '040102', '零售出库', '0401', '/pages/bill/retail_out_list.html', b'0', '0405', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (211, '040104', '零售退货', '0401', '/pages/bill/retail_back_list.html', b'0', '0407', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (212, '070407', '收预付款', '0704', '/pages/financial/advance_in.html', b'0', '0495', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (217, '01020102', '客户信息', '0102', '/pages/manage/customer.html', b'0', '0262', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (218, '01020103', '会员信息', '0102', '/pages/manage/member.html', b'0', '0263', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (220, '010103', '计量单位', '0101', '/pages/manage/unit.html', b'0', '0245', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (225, '0401', '零售管理', '0', '', b'0', '0101', b'0', '电脑版', '', 'icon-present', '0');
INSERT INTO `jsh_function` VALUES (226, '030106', '入库明细', '0301', '/pages/reports/in_detail.html', b'0', '0640', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (227, '030107', '出库明细', '0301', '/pages/reports/out_detail.html', b'0', '0645', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (228, '030108', '入库汇总', '0301', '/pages/reports/in_material_count.html', b'0', '0650', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (229, '030109', '出库汇总', '0301', '/pages/reports/out_material_count.html', b'0', '0655', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (232, '080109', '组装单', '0801', '/pages/bill/assemble_list.html', b'0', '0809', b'0', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (233, '080111', '拆卸单', '0801', '/pages/bill/disassemble_list.html', b'0', '0811', b'0', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (234, '000105', '系统配置', '0001', '/pages/manage/systemConfig.html', b'0', '0165', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (235, '030110', '客户对账', '0301', '/pages/reports/customer_account.html', b'0', '0660', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (236, '000106', '成品属性', '0001', '/pages/materials/materialProperty.html', b'0', '0168', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (237, '030111', '供应商对账', '0301', '/pages/reports/vendor_account.html', b'0', '0665', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (239, '0801', '仓库管理', '0', '', b'0', '0420', b'1', '电脑版', '', 'icon-layers', '0');
INSERT INTO `jsh_function` VALUES (240, '010104', '序列号', '0101', '/pages/manage/serialNumber.html', b'0', '0246', b'0', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (241, '050202', '采购订单', '0502', '/pages/bill/purchase_orders_list.html', b'0', '0335', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (242, '060301', '销售订单', '0603', '/pages/manage/order.html', b'0', '0392', b'1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (243, '000108', '机构管理', '0001', '/pages/manage/organization.html', b'1', '0150', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (244, '030112', '库存预警', '0301', '/pages/reports/stock_warning_report.html', b'0', '0670', b'1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (245, '000107', '插件管理', '0001', '/pages/manage/plugin.html', b'0', '0170', b'1', '电脑版', '1', 'icon-notebook', '0');
INSERT INTO `jsh_function` VALUES (248, '010203', '工序管理', '0102', '/pages/manage/gongxu.html', b'0', '0281', b'1', NULL, '1', 'icon-directions', '0');
INSERT INTO `jsh_function` VALUES (249, '080101', '出货管理', '0', '', b'0', '0465', b'1', NULL, '1', 'icon-hourglass', '0');
INSERT INTO `jsh_function` VALUES (250, '010101020101', '待出货', '080101', '/pages/manage/dch_order.html', b'0', '0298', b'1', NULL, '1', 'icon-screen-desktop', '0');
INSERT INTO `jsh_function` VALUES (251, '010101020102', '已出货', '080101', '/pages/manage/ych_order.html', b'0', '0299', b'1', NULL, '1', 'icon-drawer', '0');
INSERT INTO `jsh_function` VALUES (252, '010103', '原材料管理', '0101', '/pages/manage/role.html', b'0', '0241', b'1', NULL, '2', 'icon-screen-smartphone', '0');
INSERT INTO `jsh_function` VALUES (253, '010102', '混合料管理', '0101', '', b'0', '0624', b'1', NULL, '2', 'icon-map', '0');
INSERT INTO `jsh_function` VALUES (254, '060301', '待审批', '0603', '/pages/manage/dsp_order.html', b'0', '0201', b'1', NULL, '2,1', 'icon-exclamation', '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_gongxu
-- ----------------------------
DROP TABLE IF EXISTS `jsh_gongxu`;
CREATE TABLE `jsh_gongxu` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工序名称',
  `delete_flag` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT '0' COMMENT '0:删除，1:为删除',
  `tenant_id` int(11) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of jsh_gongxu
-- ----------------------------
BEGIN;
INSERT INTO `jsh_gongxu` VALUES (12, '烧炉', '1', 63);
INSERT INTO `jsh_gongxu` VALUES (21, '返烧', '0', 63);
INSERT INTO `jsh_gongxu` VALUES (22, '加压', '0', 63);
INSERT INTO `jsh_gongxu` VALUES (23, '2222', '1', 63);
INSERT INTO `jsh_gongxu` VALUES (24, '深冷', '0', 63);
INSERT INTO `jsh_gongxu` VALUES (25, '回火', '0', 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_in_out_item
-- ----------------------------
DROP TABLE IF EXISTS `jsh_in_out_item`;
CREATE TABLE `jsh_in_out_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='收支项目';

-- ----------------------------
-- Records of jsh_in_out_item
-- ----------------------------
BEGIN;
INSERT INTO `jsh_in_out_item` VALUES (21, '快递费', '支出', '', 63, '0');
INSERT INTO `jsh_in_out_item` VALUES (22, '房租收入', '收入', '', 63, '0');
INSERT INTO `jsh_in_out_item` VALUES (23, '利息收入', '收入', '收入', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_log
-- ----------------------------
DROP TABLE IF EXISTS `jsh_log`;
CREATE TABLE `jsh_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `operation` varchar(500) DEFAULT NULL COMMENT '操作模块名称',
  `client_ip` varchar(50) DEFAULT NULL COMMENT '客户端IP',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '操作状态 0==成功，1==失败',
  `content` varchar(1000) DEFAULT NULL COMMENT '详情',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`),
  KEY `FKF2696AA13E226853` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7236 DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Records of jsh_log
-- ----------------------------
BEGIN;
INSERT INTO `jsh_log` VALUES (6800, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 00:54:43', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6801, 120, '用户', '172.16.138.235', '2020-10-28 00:58:47', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6802, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:02:21', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6803, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:02:42', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6804, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:17:16', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6805, 120, '用户', '172.16.138.235', '2020-10-28 03:20:47', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6806, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:23:12', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6807, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:38:36', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6808, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:55:28', 0, '登录jsh', 63);
INSERT INTO `jsh_log` VALUES (6809, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 03:56:50', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6810, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:57:45', 0, '新增宗镜录', NULL);
INSERT INTO `jsh_log` VALUES (6811, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:58:00', 0, '修改总经理', NULL);
INSERT INTO `jsh_log` VALUES (6812, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:58:05', 0, '删除[角色abc]', NULL);
INSERT INTO `jsh_log` VALUES (6813, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:58:07', 0, '删除[销售代表]', NULL);
INSERT INTO `jsh_log` VALUES (6814, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:58:13', 0, '删除[销售经理]', NULL);
INSERT INTO `jsh_log` VALUES (6815, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 03:58:16', 0, '删除[租户]', NULL);
INSERT INTO `jsh_log` VALUES (6816, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:00:03', 0, '修改高啟骏', NULL);
INSERT INTO `jsh_log` VALUES (6817, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:00:50', 0, '新增财务经理', NULL);
INSERT INTO `jsh_log` VALUES (6818, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:08:44', 0, '修改管理员', NULL);
INSERT INTO `jsh_log` VALUES (6819, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:15:00', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6820, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:20:56', 0, '修改财务经理', NULL);
INSERT INTO `jsh_log` VALUES (6821, 120, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:21:04', 0, '修改总经理', NULL);
INSERT INTO `jsh_log` VALUES (6822, 120, '机构', '0:0:0:0:0:0:0:1', '2020-10-28 04:23:26', 0, '修改太仓中材钨业科技有限公司', NULL);
INSERT INTO `jsh_log` VALUES (6823, 120, '机构', '0:0:0:0:0:0:0:1', '2020-10-28 04:24:33', 0, '修改太仓市', NULL);
INSERT INTO `jsh_log` VALUES (6824, 120, '机构', '0:0:0:0:0:0:0:1', '2020-10-28 04:25:06', 0, '修改太仓中材钨业科技有限公司', NULL);
INSERT INTO `jsh_log` VALUES (6825, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:25:46', 0, '修改63', NULL);
INSERT INTO `jsh_log` VALUES (6826, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:25:51', 0, '删除[test123]', NULL);
INSERT INTO `jsh_log` VALUES (6827, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:26:05', 0, '登录jsh', 63);
INSERT INTO `jsh_log` VALUES (6828, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:26:58', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6829, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-28 04:27:38', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6830, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:28:26', 0, '新增总经理', 63);
INSERT INTO `jsh_log` VALUES (6831, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:28:42', 0, '新增财务经理', 63);
INSERT INTO `jsh_log` VALUES (6832, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-28 04:29:04', 0, '新增生产经理', 63);
INSERT INTO `jsh_log` VALUES (6833, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-28 04:29:21', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6834, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:30:54', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6835, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 04:31:05', 0, '登录jsh', 63);
INSERT INTO `jsh_log` VALUES (6836, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 09:12:13', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6837, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 20:08:17', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6838, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 20:11:12', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6839, 120, '系统配置', '0:0:0:0:0:0:0:1', '2020-10-28 20:11:27', 0, '删除9', NULL);
INSERT INTO `jsh_log` VALUES (6840, 120, '用户', '172.16.138.235', '2020-10-28 20:14:01', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6841, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:14:39', 0, '新增订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6842, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:15:16', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6843, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:15:57', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6844, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:16:31', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6845, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:18:22', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6846, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:18:33', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6847, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:19:30', 0, '新增测试', NULL);
INSERT INTO `jsh_log` VALUES (6848, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:22:31', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6849, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:23:04', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6850, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:56:57', 0, '修改测试', NULL);
INSERT INTO `jsh_log` VALUES (6851, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:57:22', 0, '修改测试', NULL);
INSERT INTO `jsh_log` VALUES (6852, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 20:58:58', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6853, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 20:59:38', 0, '修改测试', NULL);
INSERT INTO `jsh_log` VALUES (6854, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:02:41', 0, '修改测试', NULL);
INSERT INTO `jsh_log` VALUES (6855, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:10:46', 0, '修改测试', NULL);
INSERT INTO `jsh_log` VALUES (6856, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:16:03', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6857, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:27:28', 0, '批量删除,id集:246', NULL);
INSERT INTO `jsh_log` VALUES (6858, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:27:45', 0, '批量删除,id集:247', NULL);
INSERT INTO `jsh_log` VALUES (6859, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:29:41', 0, '修改订单管理', NULL);
INSERT INTO `jsh_log` VALUES (6860, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 21:34:03', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6861, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 21:36:27', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6862, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 21:36:39', 0, '修改零售管理', NULL);
INSERT INTO `jsh_log` VALUES (6863, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 21:37:28', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6864, 63, '仓库', '0:0:0:0:0:0:0:1', '2020-10-28 21:40:48', 0, '修改太仓中材一号仓库', 63);
INSERT INTO `jsh_log` VALUES (6865, 63, '仓库', '0:0:0:0:0:0:0:1', '2020-10-28 21:41:26', 0, '修改太仓中材一号仓库', 63);
INSERT INTO `jsh_log` VALUES (6866, 63, '仓库', '0:0:0:0:0:0:0:1', '2020-10-28 21:43:10', 0, '修改太仓中材二号仓库', 63);
INSERT INTO `jsh_log` VALUES (6867, 63, '仓库', '0:0:0:0:0:0:0:1', '2020-10-28 21:44:03', 0, '修改太仓中材三号仓库', 63);
INSERT INTO `jsh_log` VALUES (6868, 63, '系统配置', '0:0:0:0:0:0:0:1', '2020-10-28 21:47:32', 0, '新增太仓市中仓钨业科技有限公司', 63);
INSERT INTO `jsh_log` VALUES (6869, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 22:00:02', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6870, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-28 22:01:01', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6871, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-28 22:01:44', 0, '修改会员信息', NULL);
INSERT INTO `jsh_log` VALUES (6872, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-29 01:47:39', 0, '新增销售经理', 63);
INSERT INTO `jsh_log` VALUES (6873, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-29 01:48:01', 0, '新增采购经理', 63);
INSERT INTO `jsh_log` VALUES (6874, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 01:51:11', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6875, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 01:51:51', 0, '修改63', 63);
INSERT INTO `jsh_log` VALUES (6876, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 01:52:21', 0, '修改132', 63);
INSERT INTO `jsh_log` VALUES (6877, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 01:52:44', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6878, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 01:58:38', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6879, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-29 01:59:13', 0, '新增副厂长', 63);
INSERT INTO `jsh_log` VALUES (6880, 63, '角色', '0:0:0:0:0:0:0:1', '2020-10-29 01:59:40', 0, '新增普通员工', 63);
INSERT INTO `jsh_log` VALUES (6881, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 01:59:54', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6882, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 02:01:06', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6883, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 02:03:20', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6884, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 02:04:06', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6885, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 02:04:14', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6886, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:39:07', 0, '修改原料类', 63);
INSERT INTO `jsh_log` VALUES (6887, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:39:44', 0, '修改办公类', 63);
INSERT INTO `jsh_log` VALUES (6888, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:40:04', 0, '修改中材钨业', 63);
INSERT INTO `jsh_log` VALUES (6889, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:40:36', 0, '新增原料类', 63);
INSERT INTO `jsh_log` VALUES (6890, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:41:17', 0, '新增城市区域', 63);
INSERT INTO `jsh_log` VALUES (6891, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:41:36', 0, '新增苏州', 63);
INSERT INTO `jsh_log` VALUES (6892, 63, '商品类型', '0:0:0:0:0:0:0:1', '2020-10-29 02:41:54', 0, '新增太仓', 63);
INSERT INTO `jsh_log` VALUES (6893, 63, '商家', '0:0:0:0:0:0:0:1', '2020-10-29 02:47:56', 0, '修改苏州科达科技', 63);
INSERT INTO `jsh_log` VALUES (6894, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 03:40:09', 0, '新增工序管理', NULL);
INSERT INTO `jsh_log` VALUES (6895, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 03:41:19', 0, '修改工序管理', NULL);
INSERT INTO `jsh_log` VALUES (6896, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:24:28', 0, '新增', NULL);
INSERT INTO `jsh_log` VALUES (6897, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:25:36', 0, '修改75', NULL);
INSERT INTO `jsh_log` VALUES (6898, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:26:22', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (6899, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:26:31', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (6900, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:55:26', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6901, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:55:35', 0, '修改76', 63);
INSERT INTO `jsh_log` VALUES (6902, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:56:21', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6903, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:56:29', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (6904, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:56:34', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (6905, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 04:56:40', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (6906, 132, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 04:56:52', 0, '登录duanzhifei', 63);
INSERT INTO `jsh_log` VALUES (6907, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 08:19:07', 0, '新增考勤管理', NULL);
INSERT INTO `jsh_log` VALUES (6908, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:19:35', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (6909, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:19:41', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (6910, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:20:35', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6911, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:21:54', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6912, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:22:23', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6913, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:22:28', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (6914, 132, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:22:36', 0, '登录duanzhifei', 63);
INSERT INTO `jsh_log` VALUES (6915, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 08:25:50', 0, '新增工时分析', NULL);
INSERT INTO `jsh_log` VALUES (6916, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:26:25', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6917, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 08:28:55', 0, '修改工时分析', NULL);
INSERT INTO `jsh_log` VALUES (6918, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:29:03', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (6919, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:29:07', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (6920, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:29:31', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6921, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:29:34', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (6922, 132, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:29:43', 0, '登录duanzhifei', 63);
INSERT INTO `jsh_log` VALUES (6923, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 08:30:44', 0, '修改考勤管理', NULL);
INSERT INTO `jsh_log` VALUES (6924, 120, '功能', '0:0:0:0:0:0:0:1', '2020-10-29 08:30:56', 0, '修改工时分析', NULL);
INSERT INTO `jsh_log` VALUES (6925, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:31:24', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6926, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:31:41', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6927, 132, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:37:59', 0, '登录duanzhifei', 63);
INSERT INTO `jsh_log` VALUES (6928, 63, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:42:44', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6929, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:45:14', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (6930, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 08:55:18', 0, '新增', NULL);
INSERT INTO `jsh_log` VALUES (6931, 137, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:55:28', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (6932, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:55:58', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6933, 137, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:56:14', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (6934, 137, '角色', '0:0:0:0:0:0:0:1', '2020-10-29 08:57:26', 0, '新增测试', 137);
INSERT INTO `jsh_log` VALUES (6935, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 08:59:37', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6936, 137, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 09:07:28', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (6937, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 09:13:54', 0, '新增', NULL);
INSERT INTO `jsh_log` VALUES (6938, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 09:13:56', 0, '新增', NULL);
INSERT INTO `jsh_log` VALUES (6939, 137, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 09:46:04', 0, '新增', 137);
INSERT INTO `jsh_log` VALUES (6940, 137, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 09:46:53', 0, '新增', 137);
INSERT INTO `jsh_log` VALUES (6941, 137, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 09:47:04', 0, '修改81', 137);
INSERT INTO `jsh_log` VALUES (6942, 120, '用户', '0:0:0:0:0:0:0:1', '2020-10-29 09:47:59', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6943, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-10-29 09:48:58', 0, '新增', NULL);
INSERT INTO `jsh_log` VALUES (6944, 137, '用户', '0:0:0:0:0:0:0:1', '2020-10-31 07:19:35', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (6945, 137, '用户', '0:0:0:0:0:0:0:1', '2020-11-01 00:51:36', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (6946, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-01 00:52:19', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6947, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-01 01:00:54', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6948, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-03 03:21:08', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6949, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-03 03:21:12', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6950, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-04 19:38:39', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6951, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-05 03:36:40', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6952, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-05 19:15:21', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6953, 63, '单据', '0:0:0:0:0:0:0:1', '2020-11-05 19:54:42', 0, '新增XSDD00000000405', 63);
INSERT INTO `jsh_log` VALUES (6954, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-06 03:04:51', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6955, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-07 04:48:32', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (6956, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-09 20:33:55', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6957, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:34:19', 0, '修改考勤管理', NULL);
INSERT INTO `jsh_log` VALUES (6958, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:35:02', 0, '修改成品属性', NULL);
INSERT INTO `jsh_log` VALUES (6959, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:35:12', 0, '修改成品类别', NULL);
INSERT INTO `jsh_log` VALUES (6960, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:35:22', 0, '修改成品信息', NULL);
INSERT INTO `jsh_log` VALUES (6961, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:35:38', 0, '修改产品管理', NULL);
INSERT INTO `jsh_log` VALUES (6962, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:41:16', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6963, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:41:48', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6964, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:42:14', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6965, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:56:38', 0, '修改入库管理', NULL);
INSERT INTO `jsh_log` VALUES (6966, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:56:53', 0, '修改待出库', NULL);
INSERT INTO `jsh_log` VALUES (6967, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:57:20', 0, '修改已出库', NULL);
INSERT INTO `jsh_log` VALUES (6968, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:58:08', 0, '修改待出货', NULL);
INSERT INTO `jsh_log` VALUES (6969, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 20:59:29', 0, '新增已出货', NULL);
INSERT INTO `jsh_log` VALUES (6970, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-09 21:00:06', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (6971, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-09 21:00:11', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (6972, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:03:06', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6973, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:03:27', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6974, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:03:59', 0, '修改出货管理', NULL);
INSERT INTO `jsh_log` VALUES (6975, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:04:31', 0, '修改财务管理', NULL);
INSERT INTO `jsh_log` VALUES (6976, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:16:43', 0, '修改组装单', NULL);
INSERT INTO `jsh_log` VALUES (6977, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:17:03', 0, '修改拆卸单', NULL);
INSERT INTO `jsh_log` VALUES (6978, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:17:30', 0, '修改收支项目', NULL);
INSERT INTO `jsh_log` VALUES (6979, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:20:19', 0, '修改结算账户', NULL);
INSERT INTO `jsh_log` VALUES (6980, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:20:43', 0, '修改序列号', NULL);
INSERT INTO `jsh_log` VALUES (6981, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:21:10', 0, '修改计量单位', NULL);
INSERT INTO `jsh_log` VALUES (6982, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:25:46', 0, '修改生产订单', NULL);
INSERT INTO `jsh_log` VALUES (6983, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:26:19', 0, '修改退货订单', NULL);
INSERT INTO `jsh_log` VALUES (6984, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:33:33', 0, '新增原料管理', NULL);
INSERT INTO `jsh_log` VALUES (6985, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:34:34', 0, '修改原料管理', NULL);
INSERT INTO `jsh_log` VALUES (6986, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-09 21:35:02', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (6987, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-09 21:35:10', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (6988, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:35:35', 0, '修改原材料管理', NULL);
INSERT INTO `jsh_log` VALUES (6989, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:36:20', 0, '修改成品类别', NULL);
INSERT INTO `jsh_log` VALUES (6990, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:37:07', 0, '新增混合料管理', NULL);
INSERT INTO `jsh_log` VALUES (6991, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:37:53', 0, '修改混合料管理', NULL);
INSERT INTO `jsh_log` VALUES (6992, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:38:24', 0, '修改原材料管理', NULL);
INSERT INTO `jsh_log` VALUES (6993, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 21:39:21', 0, '修改原材料管理', NULL);
INSERT INTO `jsh_log` VALUES (6994, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 23:56:01', 0, '修改原材料管理', NULL);
INSERT INTO `jsh_log` VALUES (6995, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 23:56:25', 0, '修改待出货', NULL);
INSERT INTO `jsh_log` VALUES (6996, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 23:57:43', 0, '修改已出货', NULL);
INSERT INTO `jsh_log` VALUES (6997, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-09 23:57:52', 0, '修改待出货', NULL);
INSERT INTO `jsh_log` VALUES (6998, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 01:52:04', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (6999, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 01:52:28', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7000, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 02:01:57', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7001, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 02:09:03', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7002, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 03:58:12', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7003, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-10 03:59:19', 0, '修改销售订单', NULL);
INSERT INTO `jsh_log` VALUES (7004, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-10 04:11:10', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7005, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-10 05:17:03', 0, '修改71', 63);
INSERT INTO `jsh_log` VALUES (7006, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-10 05:17:09', 0, '修改71', 63);
INSERT INTO `jsh_log` VALUES (7007, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 00:15:37', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7008, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 01:16:52', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7009, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 03:07:46', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7010, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 03:12:53', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7011, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 03:26:33', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7012, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 03:29:50', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7013, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 03:35:30', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7014, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 19:05:16', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7015, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 19:30:11', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7016, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 19:47:11', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7017, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 20:04:38', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7018, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 20:37:13', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7019, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-11 21:26:48', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7020, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-11 23:41:08', 0, '新增null', 63);
INSERT INTO `jsh_log` VALUES (7021, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-11 23:44:12', 0, '新增null', 63);
INSERT INTO `jsh_log` VALUES (7022, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 01:34:16', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7023, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:34:41', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7024, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:34:51', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7025, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:35:09', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7026, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 01:46:08', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7027, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:46:47', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7028, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:47:03', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7029, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 01:58:04', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7030, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 01:58:36', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7031, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-12 01:58:52', 0, '删除', 63);
INSERT INTO `jsh_log` VALUES (7032, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 02:06:14', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7033, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 02:07:05', 0, '删除[232]', 63);
INSERT INTO `jsh_log` VALUES (7034, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 02:14:38', 0, '删除[00000466]', 63);
INSERT INTO `jsh_log` VALUES (7035, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 02:51:32', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7036, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:02:10', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7037, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:10:35', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7038, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:11:59', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7039, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:13:41', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7040, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:17:45', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7041, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:43:09', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7042, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 03:43:32', 0, '导入1条', 63);
INSERT INTO `jsh_log` VALUES (7043, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 03:44:18', 0, '导入2条', 63);
INSERT INTO `jsh_log` VALUES (7044, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 03:56:51', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7045, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:03:32', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7046, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 04:05:26', 0, '导入2条', 63);
INSERT INTO `jsh_log` VALUES (7047, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:06:44', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7048, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 04:06:53', 0, '导入0条', 63);
INSERT INTO `jsh_log` VALUES (7049, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 04:08:39', 0, '导入0条', 63);
INSERT INTO `jsh_log` VALUES (7050, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:10:26', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7051, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:13:07', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7052, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 04:13:24', 0, '导入1条', 63);
INSERT INTO `jsh_log` VALUES (7053, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:13:49', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7054, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:14:08', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7055, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:14:26', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7056, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:14:42', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7057, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:15:02', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7058, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-12 04:15:17', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7059, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:36:09', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7060, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:42:48', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7061, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:46:20', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7062, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:50:53', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7063, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:54:38', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7064, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-12 04:55:04', 0, '修改库存管理', NULL);
INSERT INTO `jsh_log` VALUES (7065, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:55:11', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7066, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 04:58:21', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7067, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:13:58', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7068, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:15:52', 0, '删除[baobei]', NULL);
INSERT INTO `jsh_log` VALUES (7069, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:21:52', 0, '修改135', NULL);
INSERT INTO `jsh_log` VALUES (7070, 137, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:22:48', 0, '登录18202155142', 137);
INSERT INTO `jsh_log` VALUES (7071, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:25:15', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7072, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:25:51', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7073, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:36:15', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7074, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:51:25', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7075, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:51:37', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7076, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:52:03', 0, '修改63', 63);
INSERT INTO `jsh_log` VALUES (7077, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:52:48', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7078, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:52:58', 0, '修改76', 63);
INSERT INTO `jsh_log` VALUES (7079, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:53:24', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7080, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:53:36', 0, '修改85', 63);
INSERT INTO `jsh_log` VALUES (7081, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:54:15', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7082, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:54:22', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (7083, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:54:51', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7084, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:55:00', 0, '修改86', 63);
INSERT INTO `jsh_log` VALUES (7085, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:55:22', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7086, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:55:30', 0, '修改77', 63);
INSERT INTO `jsh_log` VALUES (7087, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:55:53', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7088, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:56:01', 0, '修改87', 63);
INSERT INTO `jsh_log` VALUES (7089, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:56:10', 0, '新增', 63);
INSERT INTO `jsh_log` VALUES (7090, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:56:16', 0, '修改88', 63);
INSERT INTO `jsh_log` VALUES (7091, 142, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:57:03', 0, '登录liuchengfan', 63);
INSERT INTO `jsh_log` VALUES (7092, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:57:55', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7093, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 05:58:05', 0, '修改76', 63);
INSERT INTO `jsh_log` VALUES (7094, 142, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:58:31', 0, '登录liuchengfan', 63);
INSERT INTO `jsh_log` VALUES (7095, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 05:59:42', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7096, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 06:01:10', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7097, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 06:08:25', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7098, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 06:09:23', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7099, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 06:09:34', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7100, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 06:25:42', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7101, 63, '订单', '0:0:0:0:0:0:0:1', '2020-11-12 06:28:11', 0, '导入0条', 63);
INSERT INTO `jsh_log` VALUES (7102, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 23:28:06', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7103, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 23:31:56', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7104, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 23:33:30', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7105, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 23:38:24', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7106, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-12 23:41:10', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7107, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 23:41:46', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7108, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 23:41:51', 0, '修改88', NULL);
INSERT INTO `jsh_log` VALUES (7109, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-12 23:42:00', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7110, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-12 23:53:52', 0, '修改待出货', NULL);
INSERT INTO `jsh_log` VALUES (7111, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-13 01:32:23', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7112, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-13 01:36:29', 0, '修改MH3', 63);
INSERT INTO `jsh_log` VALUES (7113, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-13 01:44:06', 0, '修改KG', 63);
INSERT INTO `jsh_log` VALUES (7114, 63, '商家', '0:0:0:0:0:0:0:1', '2020-11-13 01:47:04', 0, '修改HET', 63);
INSERT INTO `jsh_log` VALUES (7115, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-13 02:46:53', 0, '新增高啟骏', 63);
INSERT INTO `jsh_log` VALUES (7116, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-13 02:50:03', 0, '删除[123121323]', 63);
INSERT INTO `jsh_log` VALUES (7117, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-16 19:02:27', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7118, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-16 23:41:40', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7119, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 02:46:02', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7120, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 03:28:48', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7121, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 04:45:47', 0, '新增高啟骏', 63);
INSERT INTO `jsh_log` VALUES (7122, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 05:05:08', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7123, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 05:06:28', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7124, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 05:35:05', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7125, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 05:35:19', 0, '修改gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7126, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 05:39:56', 0, '修改gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7127, 63, '财务', '0:0:0:0:0:0:0:1', '2020-11-23 06:01:39', 0, '修改SR20200913184412', 63);
INSERT INTO `jsh_log` VALUES (7128, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 06:51:00', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7129, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 07:47:06', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7130, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 07:58:05', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7131, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 08:17:43', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7132, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 08:20:51', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7133, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:23:16', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7134, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:26:58', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7135, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:27:06', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7136, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:29:30', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7137, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:30:06', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7138, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:30:14', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7139, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:30:20', 0, '修改高啟骏', 63);
INSERT INTO `jsh_log` VALUES (7140, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:31:29', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7141, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:31:44', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7142, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:31:51', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7143, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:32:02', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7144, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:32:12', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7145, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:32:20', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7146, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:32:53', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7147, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:33:33', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7148, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 08:37:27', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7149, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 08:57:07', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7150, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 09:07:26', 0, '修改gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7151, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 09:07:40', 0, '修改null', 63);
INSERT INTO `jsh_log` VALUES (7152, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 09:08:40', 0, '修改gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7153, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 09:39:45', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7154, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 10:04:49', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7155, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 10:06:19', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7156, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 10:10:54', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7157, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 10:13:23', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7158, 63, '功能', '0:0:0:0:0:0:0:1', '2020-11-23 10:15:36', 0, '修改已出货', 63);
INSERT INTO `jsh_log` VALUES (7159, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 20:07:18', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7160, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 23:26:38', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7161, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-23 23:44:11', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7162, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-23 23:44:32', 0, '删除16', 63);
INSERT INTO `jsh_log` VALUES (7163, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:01:06', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7164, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:03:48', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7165, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:05:42', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7166, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:09:14', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7167, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:10:21', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7168, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:12:57', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7169, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:15:32', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7170, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:18:57', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7171, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:20:49', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7172, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:34:42', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7173, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-24 00:34:55', 0, '删除19', 63);
INSERT INTO `jsh_log` VALUES (7174, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:39:30', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7175, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:41:56', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7176, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:50:28', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7177, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:54:06', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7178, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 00:55:16', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7179, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:03:02', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7180, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:06:37', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7181, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-24 01:06:48', 0, '删除21', 63);
INSERT INTO `jsh_log` VALUES (7182, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:12:33', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7183, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:13:24', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7184, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:16:47', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7185, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:18:04', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7186, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:29:17', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7187, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:42:56', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7188, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 01:55:13', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7189, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 02:07:37', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7190, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 04:21:49', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7191, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 05:41:52', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7192, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-24 20:52:33', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7193, 63, '功能', '0:0:0:0:0:0:0:1', '2020-11-25 02:32:26', 0, '修改工序管理', 63);
INSERT INTO `jsh_log` VALUES (7194, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-25 02:35:00', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7195, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-25 02:44:34', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7196, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-25 03:01:15', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7197, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:01:27', 0, '批量删除,id集:1', 63);
INSERT INTO `jsh_log` VALUES (7198, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-25 03:09:09', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7199, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:09:24', 0, '删除12', 63);
INSERT INTO `jsh_log` VALUES (7200, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:11:25', 0, '修改测试1', 63);
INSERT INTO `jsh_log` VALUES (7201, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:11:33', 0, '修改测试工序', 63);
INSERT INTO `jsh_log` VALUES (7202, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:12:34', 0, '新增烧炉', 63);
INSERT INTO `jsh_log` VALUES (7203, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-25 03:19:29', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7204, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:19:41', 0, '新增2222', 63);
INSERT INTO `jsh_log` VALUES (7205, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:20:10', 0, '删除23', 63);
INSERT INTO `jsh_log` VALUES (7206, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:28:54', 0, '修改返烧', 63);
INSERT INTO `jsh_log` VALUES (7207, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:29:11', 0, '修改加压', 63);
INSERT INTO `jsh_log` VALUES (7208, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:29:21', 0, '新增深冷', 63);
INSERT INTO `jsh_log` VALUES (7209, 63, '经手人', '0:0:0:0:0:0:0:1', '2020-11-25 03:29:30', 0, '新增回火', 63);
INSERT INTO `jsh_log` VALUES (7210, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 01:50:46', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7211, 63, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 02:16:27', 0, '修改生产订单', 63);
INSERT INTO `jsh_log` VALUES (7212, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:21:50', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7213, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:26:06', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7214, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:29:24', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7215, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:33:44', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7216, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:39:11', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7217, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:41:01', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7218, 63, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:51:12', 0, '登录gaoqijun', 63);
INSERT INTO `jsh_log` VALUES (7219, 63, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 02:55:27', 0, '新增待审批', 63);
INSERT INTO `jsh_log` VALUES (7220, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:56:28', 0, '修改', 63);
INSERT INTO `jsh_log` VALUES (7221, 63, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:56:34', 0, '修改88', 63);
INSERT INTO `jsh_log` VALUES (7222, 120, '用户', '0:0:0:0:0:0:0:1', '2020-11-30 02:57:12', 0, '登录admin', NULL);
INSERT INTO `jsh_log` VALUES (7223, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:58:18', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7224, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:58:28', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7225, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:58:32', 0, '修改88', NULL);
INSERT INTO `jsh_log` VALUES (7226, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:59:04', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7227, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 02:59:08', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (7228, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 03:01:25', 0, '修改待审批', NULL);
INSERT INTO `jsh_log` VALUES (7229, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 03:06:53', 0, '修改待审批', NULL);
INSERT INTO `jsh_log` VALUES (7230, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 03:07:40', 0, '修改待审批', NULL);
INSERT INTO `jsh_log` VALUES (7231, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 03:29:27', 0, '修改待审批', NULL);
INSERT INTO `jsh_log` VALUES (7232, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 03:32:29', 0, '修改', NULL);
INSERT INTO `jsh_log` VALUES (7233, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 03:32:34', 0, '修改5', NULL);
INSERT INTO `jsh_log` VALUES (7234, 120, '功能', '0:0:0:0:0:0:0:1', '2020-11-30 03:33:34', 0, '修改待审批', NULL);
INSERT INTO `jsh_log` VALUES (7235, 120, '关联关系', '0:0:0:0:0:0:0:1', '2020-11-30 03:36:04', 0, '修改5', NULL);
COMMIT;

-- ----------------------------
-- Table structure for jsh_material
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material`;
CREATE TABLE `jsh_material` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_id` bigint(20) DEFAULT NULL COMMENT '产品类型id',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `mfrs` varchar(50) DEFAULT NULL COMMENT '制造商',
  `safety_stock` decimal(24,6) DEFAULT NULL COMMENT '安全存量（KG）',
  `model` varchar(50) DEFAULT NULL COMMENT '型号',
  `standard` varchar(50) DEFAULT NULL COMMENT '规格',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `unit` varchar(50) DEFAULT NULL COMMENT '单位-单个',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `unit_id` bigint(20) DEFAULT NULL COMMENT '计量单位Id',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用 0-禁用  1-启用',
  `other_field1` varchar(50) DEFAULT NULL COMMENT '自定义1',
  `other_field2` varchar(50) DEFAULT NULL COMMENT '自定义2',
  `other_field3` varchar(50) DEFAULT NULL COMMENT '自定义3',
  `enable_serial_number` varchar(1) DEFAULT '0' COMMENT '是否开启序列号，0否，1是',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`),
  KEY `FK675951272AB6672C` (`category_id`),
  KEY `UnitId` (`unit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=589 DEFAULT CHARSET=utf8 COMMENT='产品表';

-- ----------------------------
-- Records of jsh_material
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material` VALUES (568, 17, '商品1', '制1', 100.000000, 'sp1', '', '', '个', '', NULL, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (569, 17, '商品2', '', 200.000000, 'sp2', '', '', '只', '', NULL, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (570, 17, '商品3', '', 300.000000, 'sp3', '', '', '个', '', NULL, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (577, NULL, '商品8', '', NULL, 'sp8', '', '', '', '', 15, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (579, 21, '商品17', '', NULL, 'sp17', '', '', '', '', 15, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (586, 17, '序列号商品测试', '', NULL, 'xlh123', '', '', '个', '', NULL, b'1', '', '', '', '1', 63, '0');
INSERT INTO `jsh_material` VALUES (587, 17, '商品test1', '南通中远', NULL, '', 'test1', '', '个', '', NULL, b'1', '', '', '', '0', 63, '0');
INSERT INTO `jsh_material` VALUES (588, 21, '商品200', '', 112.000000, '', '300ml', '', '个', '', NULL, b'1', '', '', '', '0', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_material_category
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_category`;
CREATE TABLE `jsh_material_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `category_level` smallint(6) DEFAULT NULL COMMENT '等级',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级id',
  `sort` varchar(10) DEFAULT NULL COMMENT '显示顺序',
  `status` varchar(1) DEFAULT '0' COMMENT '状态，0系统默认，1启用，2删除',
  `serial_no` varchar(100) DEFAULT NULL COMMENT '编号',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`),
  KEY `FK3EE7F725237A77D8` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='产品类型表';

-- ----------------------------
-- Records of jsh_material_category
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_category` VALUES (17, '中材钨业', NULL, -1, '1', '1', '1', '原料', '2019-04-10 22:18:12', 63, '2020-10-29 02:40:04', 63, 63);
INSERT INTO `jsh_material_category` VALUES (21, '办公类', NULL, 17, '2', '1', '2', '办公类', '2020-07-20 23:08:44', 63, '2020-10-29 02:39:44', 63, 63);
INSERT INTO `jsh_material_category` VALUES (22, '原料类', NULL, 17, '3', '1', '3', '原料类', '2020-10-29 02:40:36', 63, '2020-10-29 02:40:36', 63, 63);
INSERT INTO `jsh_material_category` VALUES (23, '城市区域', NULL, 17, '4', '1', '4', '城市来划分', '2020-10-29 02:41:17', 63, '2020-10-29 02:41:17', 63, 63);
INSERT INTO `jsh_material_category` VALUES (24, '苏州', NULL, 23, '5', '1', '5', '苏州区域', '2020-10-29 02:41:36', 63, '2020-10-29 02:41:36', 63, 63);
INSERT INTO `jsh_material_category` VALUES (25, '太仓', NULL, 23, '6', '1', '6', '太仓区域', '2020-10-29 02:41:54', 63, '2020-10-29 02:41:54', 63, 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_material_current_stock
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_current_stock`;
CREATE TABLE `jsh_material_current_stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `current_number` decimal(24,6) DEFAULT NULL COMMENT '当前库存数量',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品当前库存';

-- ----------------------------
-- Records of jsh_material_current_stock
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_current_stock` VALUES (1, 587, 14, -30.000000, 63, '0');
INSERT INTO `jsh_material_current_stock` VALUES (2, 570, 14, 48.000000, 63, '0');
INSERT INTO `jsh_material_current_stock` VALUES (3, 568, 14, 19.000000, 63, '0');
INSERT INTO `jsh_material_current_stock` VALUES (4, 569, 14, 50.000000, 63, '0');
INSERT INTO `jsh_material_current_stock` VALUES (5, 588, 14, 13.000000, 63, '0');
INSERT INTO `jsh_material_current_stock` VALUES (6, 569, 15, 122.000000, 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_material_extend
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_extend`;
CREATE TABLE `jsh_material_extend` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '商品id',
  `bar_code` varchar(50) DEFAULT NULL COMMENT '商品条码',
  `commodity_unit` varchar(50) DEFAULT NULL COMMENT '商品单位',
  `purchase_decimal` decimal(24,6) DEFAULT NULL COMMENT '采购价格',
  `commodity_decimal` decimal(24,6) DEFAULT NULL COMMENT '零售价格',
  `wholesale_decimal` decimal(24,6) DEFAULT NULL COMMENT '销售价格',
  `low_decimal` decimal(24,6) DEFAULT NULL COMMENT '最低售价',
  `default_flag` varchar(1) DEFAULT '1' COMMENT '是否为默认单位，1是，0否',
  `create_time` datetime DEFAULT NULL COMMENT '创建日期',
  `create_serial` varchar(50) DEFAULT NULL COMMENT '创建人编码',
  `update_serial` varchar(50) DEFAULT NULL COMMENT '更新人编码',
  `update_time` bigint(20) DEFAULT NULL COMMENT '更新时间戳',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品价格扩展';

-- ----------------------------
-- Records of jsh_material_extend
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_extend` VALUES (1, 587, '1000', '个', 11.000000, 22.000000, 22.000000, 22.000000, '1', '2020-02-20 23:22:03', 'jsh', 'jsh', 1595263657135, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (2, 568, '1001', '个', 11.000000, 15.000000, 15.000000, 15.000000, '1', '2020-02-20 23:44:57', 'jsh', 'jsh', 1595265439418, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (3, 569, '1002', '只', 10.000000, 15.000000, 15.000000, 13.000000, '1', '2020-02-20 23:45:15', 'jsh', 'jsh', 1582213514731, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (4, 570, '1003', '个', 8.000000, 15.000000, 14.000000, 13.000000, '1', '2020-02-20 23:45:37', 'jsh', 'jsh', 1587657604430, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (5, 577, '1004', '个', 10.000000, 20.000000, 20.000000, 20.000000, '1', '2020-02-20 23:46:36', 'jsh', 'jsh', 1582213596494, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (6, 577, '1005', '箱', 120.000000, 240.000000, 240.000000, 240.000000, '0', '2020-02-20 23:46:36', 'jsh', 'jsh', 1582213596497, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (7, 579, '1006', '个', 20.000000, 30.000000, 30.000000, 30.000000, '1', '2020-02-20 23:47:04', 'jsh', 'jsh', 1595264270458, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (8, 579, '1007', '箱', 240.000000, 360.000000, 360.000000, 360.000000, '0', '2020-02-20 23:47:04', 'jsh', 'jsh', 1595264270466, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (9, 586, '1008', '个', 12.000000, 15.000000, 15.000000, 15.000000, '1', '2020-02-20 23:47:23', 'jsh', 'jsh', 1595254981896, 63, '0');
INSERT INTO `jsh_material_extend` VALUES (10, 588, '1009', '个', 11.000000, 22.000000, 22.000000, 22.000000, '1', '2020-07-21 00:58:15', 'jsh', 'jsh', 1595264315873, 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_material_initial_stock
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_initial_stock`;
CREATE TABLE `jsh_material_initial_stock` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `depot_id` bigint(20) DEFAULT NULL COMMENT '仓库id',
  `number` decimal(24,6) DEFAULT NULL COMMENT '初始库存数量',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品初始库存';

-- ----------------------------
-- Records of jsh_material_initial_stock
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_initial_stock` VALUES (123, 587, 14, 5.000000, 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_material_property
-- ----------------------------
DROP TABLE IF EXISTS `jsh_material_property`;
CREATE TABLE `jsh_material_property` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `native_name` varchar(50) DEFAULT NULL COMMENT '原始名称',
  `enabled` bit(1) DEFAULT NULL COMMENT '是否启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `another_name` varchar(50) DEFAULT NULL COMMENT '别名',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='产品扩展字段表';

-- ----------------------------
-- Records of jsh_material_property
-- ----------------------------
BEGIN;
INSERT INTO `jsh_material_property` VALUES (1, '规格', b'1', '02', '规格', '0');
INSERT INTO `jsh_material_property` VALUES (2, '颜色', b'1', '01', '颜色', '0');
INSERT INTO `jsh_material_property` VALUES (3, '制造商', b'1', '03', '制造商', '0');
INSERT INTO `jsh_material_property` VALUES (4, '自定义1', b'0', '04', '自定义1', '0');
INSERT INTO `jsh_material_property` VALUES (5, '自定义2', b'0', '05', '自定义2', '0');
INSERT INTO `jsh_material_property` VALUES (6, '自定义3', b'0', '06', '自定义3', '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_msg
-- ----------------------------
DROP TABLE IF EXISTS `jsh_msg`;
CREATE TABLE `jsh_msg` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msg_title` varchar(100) DEFAULT NULL COMMENT '消息标题',
  `msg_content` varchar(500) DEFAULT NULL COMMENT '消息内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `type` varchar(20) DEFAULT NULL COMMENT '消息类型',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，1未读 2已读',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_Flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='消息表';

-- ----------------------------
-- Records of jsh_msg
-- ----------------------------
BEGIN;
INSERT INTO `jsh_msg` VALUES (2, '标题1', '内容1', '2019-09-10 00:11:39', '类型1', '1', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_node
-- ----------------------------
DROP TABLE IF EXISTS `jsh_node`;
CREATE TABLE `jsh_node` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工序名称',
  `worker` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '操作者',
  `starttime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '开始时间',
  `endtime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '结束时间',
  `scorder_id` varchar(0) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '生产单id',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '0:未开始，1：加工中，2已结束',
  `ishege` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '是否合格',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Table structure for jsh_order
-- ----------------------------
DROP TABLE IF EXISTS `jsh_order`;
CREATE TABLE `jsh_order` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `dd_num` varchar(50) COLLATE utf8_unicode_ci NOT NULL COMMENT '订单编号',
  `dbcz` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '打标材质',
  `iskz` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '是否刻字',
  `khxx` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '客户',
  `guige` varchar(1000) COLLATE utf8_unicode_ci NOT NULL COMMENT '规格',
  `caizhi` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '材质',
  `number` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '数量',
  `gzdh` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '工作单号',
  `dhrq` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '订货日期',
  `yougou` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '油沟',
  `waijing` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '外径',
  `height` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '高度',
  `kongjing` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '孔径',
  `clrq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '出炉日期',
  `weight` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '重量',
  `lunum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '炉号',
  `qwchrq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '期望出货日期',
  `sjchriq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '实际出货日期',
  `delete_flag` varchar(1) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '删除标记，0未删除，1删除',
  `jingshouren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '经手人',
  `current_gongxu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '当前工序',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '状态，0:审核中，1:加工中，2：待出货，3:已出货',
  `beizhu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '备注',
  `tenant_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '租户id',
  `danjia` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '单价',
  `zongjia` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '总价',
  `chuhuoren` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '出货人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of jsh_order
-- ----------------------------
BEGIN;
INSERT INTO `jsh_order` VALUES (11, '00000465', '111111', '111', '59', '111', '111', '11', '222', '2020-09-01 10:10:10', '21', '22', '22', '22', '2020-09-01 10:10:10', '222', '22', '2020-09-01 10:10:10', '2020-09-01 10:10:10', '0', '63', '加厚', '0', '加急', '63', '10.5', '115.5', NULL);
INSERT INTO `jsh_order` VALUES (12, '00000466', '222', '222', '58', '222', '22', '2', '23', '2020-11-12 13:38:22', '2', '2', '23', '21', '2020-11-27 13:38:25', '23', '22', '2020-11-27 15:35:03', NULL, '1', '', '', '1', '12', '63', NULL, NULL, NULL);
INSERT INTO `jsh_order` VALUES (13, '232', '324', '234', '59', '243', '243', '234', '234', '2020-11-12 13:44:04', '234', '243', '234', '000', '2020-11-27 13:44:01', '234', '2342', '2020-11-28 13:44:08', '2020-09-01 10:10:10', '1', '', '', '1', '332', '63', NULL, NULL, NULL);
INSERT INTO `jsh_order` VALUES (14, '0000437', '3', '333', '58', '33', '3', '3', '3', '2020-11-19 18:13:41', '3', '3', '3', '3', '2020-11-12 18:13:43', '3', '3', '2020-11-26 18:13:46', NULL, NULL, NULL, NULL, '0', '22', '63', '69.89', '209.67000000000002', NULL);
INSERT INTO `jsh_order` VALUES (15, '0000434', '3', '333', '57', '33', '3', '3', '3', '2020-11-10 18:14:04', '3', '3', '3', '3', '2020-11-11 18:14:02', '3', '3', '2020-11-19 18:13:58', '2020-09-01 10:10:10', NULL, NULL, NULL, '3', '3', '63', '44', '132.0', '63');
INSERT INTO `jsh_order` VALUES (16, '0000438', '3', '434', '59', '4', '4', '4', '5', '2020-11-26 18:14:19', '5', '5', '5', '5', '2020-11-27 18:14:17', '5', '5', '2020-11-27 18:14:22', '2020-09-01 10:10:10', NULL, NULL, NULL, '3', '3', '63', '55', '220.0', '63');
INSERT INTO `jsh_order` VALUES (17, '0000439', '3', '333', '60', '33', '3', '3', '3', '2020-11-20 18:14:34', '3', '3', '3', '3', '2020-11-18 18:14:31', '3', '3', '2020-11-21 18:14:36', NULL, NULL, NULL, NULL, '0', '3', '63', '66.4', '199.20000000000002', NULL);
INSERT INTO `jsh_order` VALUES (18, '0000435', '3', '434', '58', '4', '4', '4', '5', '2020-11-12 18:14:54', '5', '5', '5', '5', '2020-11-20 18:14:57', '5', '5', '2020-11-27 18:14:59', NULL, NULL, NULL, NULL, '0', '3', '63', '56.3', '225.2', NULL);
INSERT INTO `jsh_order` VALUES (19, '0000436', '3234', '434', '57', '43', '43', '43', '34', '2020-11-12 18:15:08', '34', '34', '34', '43', '2020-11-11 18:15:10', '34', '43', '2020-11-21 18:15:13', '2020-10-31 10:10:10', NULL, NULL, NULL, '3', '3', '63', '33.5', '1440.5', '63');
INSERT INTO `jsh_order` VALUES (20, '123121323', '123', '123123123', '59', '123', '123', '12312312', '123', '2020-11-01 16:46:47', '3123123123', '123123123', '123123123123', '12312', '2020-11-02 16:46:45', '123123', '1231231313', '2020-11-13 16:46:34', NULL, '1', '63', NULL, '2', '3', '63', NULL, NULL, NULL);
INSERT INTO `jsh_order` VALUES (21, '23232', '23', '23', '71', '333', '33', '23', '333', '2020-11-23 18:45:40', '234', '234', '2342', '323', '2020-11-24 18:45:43', '3', '234', '2020-11-16 18:45:31', '2020-11-24 15:06:45', NULL, '63', NULL, '3', '3', '63', '3223', '74129.0', '63');
COMMIT;

-- ----------------------------
-- Table structure for jsh_orga_user_rel
-- ----------------------------
DROP TABLE IF EXISTS `jsh_orga_user_rel`;
CREATE TABLE `jsh_orga_user_rel` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `orga_id` bigint(20) NOT NULL COMMENT '机构id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `user_blng_orga_dspl_seq` varchar(20) DEFAULT NULL COMMENT '用户在所属机构中显示顺序',
  `delete_flag` char(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='机构用户关系表';

-- ----------------------------
-- Records of jsh_orga_user_rel
-- ----------------------------
BEGIN;
INSERT INTO `jsh_orga_user_rel` VALUES (10, 13, 131, '2', '0', '2019-12-28 12:13:15', 63, '2020-09-13 18:42:52', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (11, 13, 63, '1', '0', '2020-09-13 18:42:45', 63, '2020-11-12 05:52:03', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (12, 13, 132, '2', '0', '2020-10-28 04:26:58', 63, '2020-10-29 01:52:21', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (13, 13, 133, '3', '0', '2020-10-29 01:51:11', 63, '2020-10-29 01:51:11', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (14, 13, 134, '4', '0', '2020-10-29 01:58:38', 63, '2020-10-29 01:58:38', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (15, 13, 135, '5', '0', '2020-10-29 02:01:06', 63, '2020-11-12 05:21:52', 120, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (16, 13, 136, '6', '0', '2020-10-29 02:03:20', 63, '2020-10-29 02:03:20', 63, 63);
INSERT INTO `jsh_orga_user_rel` VALUES (17, 13, 142, '2', '0', '2020-11-12 05:51:25', 63, '2020-11-12 05:51:25', 63, 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_organization
-- ----------------------------
DROP TABLE IF EXISTS `jsh_organization`;
CREATE TABLE `jsh_organization` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `org_no` varchar(20) DEFAULT NULL COMMENT '机构编号',
  `org_full_name` varchar(500) DEFAULT NULL COMMENT '机构全称',
  `org_abr` varchar(20) DEFAULT NULL COMMENT '机构简称',
  `org_tpcd` varchar(9) DEFAULT NULL COMMENT '机构类型',
  `org_stcd` char(1) DEFAULT NULL COMMENT '机构状态,1未营业、2正常营业、3暂停营业、4终止营业、5已除名',
  `org_parent_no` varchar(20) DEFAULT NULL COMMENT '机构父节点编号',
  `sort` varchar(20) DEFAULT NULL COMMENT '机构显示顺序',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `org_create_time` datetime DEFAULT NULL COMMENT '机构创建时间',
  `org_stop_time` datetime DEFAULT NULL COMMENT '机构停运时间',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='机构表';

-- ----------------------------
-- Records of jsh_organization
-- ----------------------------
BEGIN;
INSERT INTO `jsh_organization` VALUES (12, '001', '太仓市', '太仓重工业', NULL, '2', '-1', '001', '', '2019-12-28 12:13:01', 63, '2020-10-28 04:24:33', 120, '2020-10-31 04:23:18', NULL, 63);
INSERT INTO `jsh_organization` VALUES (13, 'tczc', '太仓中材钨业科技有限公司', '太仓中材', NULL, '2', '001', '22', '', '2020-07-21 00:09:57', 63, '2020-10-28 04:25:06', 120, '2020-10-31 04:25:02', NULL, 63);
INSERT INTO `jsh_organization` VALUES (14, '12', '机构2', '机构2', NULL, '', 'jg1', '12', '', '2020-07-21 22:45:42', 63, '2020-07-21 22:45:51', 63, NULL, NULL, 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_person
-- ----------------------------
DROP TABLE IF EXISTS `jsh_person`;
CREATE TABLE `jsh_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='经手人表';

-- ----------------------------
-- Records of jsh_person
-- ----------------------------
BEGIN;
INSERT INTO `jsh_person` VALUES (14, '业务员', '小李', 63, '0');
INSERT INTO `jsh_person` VALUES (15, '仓管员', '小军', 63, '0');
INSERT INTO `jsh_person` VALUES (16, '财务员', '小夏', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_platform_config
-- ----------------------------
DROP TABLE IF EXISTS `jsh_platform_config`;
CREATE TABLE `jsh_platform_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `platform_key` varchar(100) DEFAULT NULL COMMENT '关键词',
  `platform_key_info` varchar(100) DEFAULT NULL COMMENT '关键词名称',
  `platform_value` varchar(200) DEFAULT NULL COMMENT '值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='平台参数';

-- ----------------------------
-- Records of jsh_platform_config
-- ----------------------------
BEGIN;
INSERT INTO `jsh_platform_config` VALUES (1, 'platform_name', '平台名称', '华夏ERP');
INSERT INTO `jsh_platform_config` VALUES (2, 'activation_code', '激活码', NULL);
COMMIT;

-- ----------------------------
-- Table structure for jsh_role
-- ----------------------------
DROP TABLE IF EXISTS `jsh_role`;
CREATE TABLE `jsh_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `value` varchar(200) DEFAULT NULL COMMENT '值',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of jsh_role
-- ----------------------------
BEGIN;
INSERT INTO `jsh_role` VALUES (4, '管理员', '全部数据', NULL, '最高管理员', NULL, '0');
INSERT INTO `jsh_role` VALUES (10, '中材管理员', '全部数据', NULL, '', NULL, '1');
INSERT INTO `jsh_role` VALUES (16, '销售经理', '全部数据', NULL, 'ddd', 63, '1');
INSERT INTO `jsh_role` VALUES (17, '销售代表', '个人数据', NULL, 'rrr', 63, '1');
INSERT INTO `jsh_role` VALUES (18, '角色abc', '本机构数据', NULL, '33333', 63, '1');
INSERT INTO `jsh_role` VALUES (19, '总经理', '本机构数据', NULL, '总经理具有最高权限', NULL, '0');
INSERT INTO `jsh_role` VALUES (20, '财务经理', '本机构数据', NULL, '财务数据管理功能', NULL, '0');
INSERT INTO `jsh_role` VALUES (21, '总经理', '本机构数据', NULL, '本机构最高管理', 63, '0');
INSERT INTO `jsh_role` VALUES (22, '财务经理', '本机构数据', NULL, '财务代表', 63, '0');
INSERT INTO `jsh_role` VALUES (23, '生产经理', '本机构数据', NULL, '生产跟踪代表', 63, '0');
INSERT INTO `jsh_role` VALUES (24, '销售经理', '本机构数据', NULL, '销售数据', 63, '0');
INSERT INTO `jsh_role` VALUES (25, '采购经理', '本机构数据', NULL, '采购数据信息', 63, '0');
INSERT INTO `jsh_role` VALUES (26, '副厂长', '本机构数据', NULL, '副厂长', 63, '0');
INSERT INTO `jsh_role` VALUES (27, '普通员工', '本机构数据', NULL, '普通员工', 63, '0');
INSERT INTO `jsh_role` VALUES (28, '测试', '个人数据', NULL, '22', 137, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_scorder
-- ----------------------------
DROP TABLE IF EXISTS `jsh_scorder`;
CREATE TABLE `jsh_scorder` (
  `id` bigint(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `khxx` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '客户信息',
  `guige` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规格',
  `caizhi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '材质',
  `number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '数量',
  `gzdbh` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '工作单编号',
  `dhrq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '订货日期',
  `yjjhrq` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '预计交货日期',
  `yougou` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '油沟',
  `yycc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '油压尺寸',
  `zhizheng` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '指针',
  `weight` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '重量',
  `ggcctx` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '规格尺寸图形',
  `cxcctx` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '成型尺寸图形',
  `youyacaozuo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '油压操作',
  `jitai` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '机台',
  `chengxingcaozucxcaozuo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '成型操作',
  `shaojieriqi` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '烧结日期',
  `shaojieluhao` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '烧结炉号',
  `zhuangluren` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '装炉人',
  `jiaohuori` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '交货日期',
  `gongxu` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '当前工序',
  `delete_flag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '是否删除',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '0:未生产，1:生产中，2:结束生产',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of jsh_scorder
-- ----------------------------
BEGIN;
INSERT INTO `jsh_scorder` VALUES (2, '71', '33', '3', '2', '3', '2020-11-30 10:10:10', '2020-12-10 10:10:10', '2', '2', '2', '22', '2', '2', '2', '2', '2', '2', '2', '2', NULL, NULL, '0', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_sequence
-- ----------------------------
DROP TABLE IF EXISTS `jsh_sequence`;
CREATE TABLE `jsh_sequence` (
  `seq_name` varchar(50) NOT NULL COMMENT '序列名称',
  `min_value` bigint(20) NOT NULL COMMENT '最小值',
  `max_value` bigint(20) NOT NULL COMMENT '最大值',
  `current_val` bigint(20) NOT NULL COMMENT '当前值',
  `increment_val` int(11) NOT NULL DEFAULT '1' COMMENT '增长步数',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`seq_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单据编号表';

-- ----------------------------
-- Records of jsh_sequence
-- ----------------------------
BEGIN;
INSERT INTO `jsh_sequence` VALUES ('depot_number_seq', 1, 999999999999999999, 487, 1, '单据编号sequence');
COMMIT;

-- ----------------------------
-- Table structure for jsh_serial_number
-- ----------------------------
DROP TABLE IF EXISTS `jsh_serial_number`;
CREATE TABLE `jsh_serial_number` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `material_id` bigint(20) DEFAULT NULL COMMENT '产品表id',
  `serial_number` varchar(64) DEFAULT NULL COMMENT '序列号',
  `is_sell` varchar(1) DEFAULT '0' COMMENT '是否卖出，0未卖出，1卖出',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建人',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新人',
  `depot_head_id` bigint(20) DEFAULT NULL COMMENT '单据主表id，用于跟踪序列号流向',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8 COMMENT='序列号表';

-- ----------------------------
-- Records of jsh_serial_number
-- ----------------------------
BEGIN;
INSERT INTO `jsh_serial_number` VALUES (105, 586, '12312323423223', '0', 'abab', '0', '2019-12-28 12:14:39', 63, '2020-07-21 00:30:32', 63, NULL, 63);
INSERT INTO `jsh_serial_number` VALUES (106, 586, '143132415952626404571', '0', '', '1', '2020-07-21 00:30:40', 63, '2020-07-21 00:30:49', 63, NULL, 63);
INSERT INTO `jsh_serial_number` VALUES (107, 586, '143132415952626404572', '0', '', '1', '2020-07-21 00:30:40', 63, '2020-07-21 00:30:47', 63, NULL, 63);
INSERT INTO `jsh_serial_number` VALUES (108, 586, '3215952626621201', '0', '', '0', '2020-07-21 00:31:02', 63, '2020-07-21 00:31:02', 63, NULL, 63);
INSERT INTO `jsh_serial_number` VALUES (109, 586, '3215952626621202', '0', '', '0', '2020-07-21 00:31:02', 63, '2020-07-21 00:31:02', 63, NULL, 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_supplier
-- ----------------------------
DROP TABLE IF EXISTS `jsh_supplier`;
CREATE TABLE `jsh_supplier` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `supplier` varchar(255) NOT NULL COMMENT '供应商名称',
  `contacts` varchar(100) DEFAULT NULL COMMENT '联系人',
  `phone_num` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `description` varchar(500) DEFAULT NULL COMMENT '备注',
  `isystem` tinyint(4) DEFAULT NULL COMMENT '是否系统自带 0==系统 1==非系统',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `enabled` bit(1) DEFAULT NULL COMMENT '启用',
  `advance_in` decimal(24,6) DEFAULT '0.000000' COMMENT '预收款',
  `begin_need_get` decimal(24,6) DEFAULT NULL COMMENT '期初应收',
  `begin_need_pay` decimal(24,6) DEFAULT NULL COMMENT '期初应付',
  `all_need_get` decimal(24,6) DEFAULT NULL COMMENT '累计应收',
  `all_need_pay` decimal(24,6) DEFAULT NULL COMMENT '累计应付',
  `fax` varchar(30) DEFAULT NULL COMMENT '传真',
  `telephone` varchar(30) DEFAULT NULL COMMENT '手机',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `tax_num` varchar(50) DEFAULT NULL COMMENT '纳税人识别号',
  `bank_name` varchar(50) DEFAULT NULL COMMENT '开户行',
  `account_number` varchar(50) DEFAULT NULL COMMENT '账号',
  `tax_rate` decimal(24,6) DEFAULT NULL COMMENT '税率',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 COMMENT='供应商/客户信息表';

-- ----------------------------
-- Records of jsh_supplier
-- ----------------------------
BEGIN;
INSERT INTO `jsh_supplier` VALUES (57, '供应商1', '小军', '12345678', '', '', NULL, '供应商', b'1', 0.000000, 0.000000, 0.000000, NULL, 0.000000, '', '', '地址1', '', '', '', 12.000000, 63, '0');
INSERT INTO `jsh_supplier` VALUES (58, 'HET', '李玉龙', '12345678', '112@182.com', '', NULL, '客户', b'1', 0.000000, 0.000000, 0.000000, -100.000000, NULL, '', '18202342434', '', '', '', '', 12.000000, 63, '0');
INSERT INTO `jsh_supplier` VALUES (59, 'KG', '陈玉龙', '123123232', '18202155142@163.com', '', NULL, '客户', b'1', 0.000000, 0.000000, 0.000000, 0.000000, NULL, '231', '18202155142', '', '', '', '', NULL, 63, '0');
INSERT INTO `jsh_supplier` VALUES (60, '昆山泰茂', '小曹', '', '', '', NULL, '会员', b'1', 970.000000, 0.000000, 0.000000, NULL, NULL, '', '13000000000', '', '', '', '', NULL, 63, '0');
INSERT INTO `jsh_supplier` VALUES (68, '供应商3', '晓丽', '', '', '', NULL, '供应商', b'1', 0.000000, 15.000000, 0.000000, NULL, -15.000000, '', '13000000000', '', '1341324', '', '', 22.000000, 63, '0');
INSERT INTO `jsh_supplier` VALUES (71, 'MH3', '高玉龙', '021055689234', '18202155142@163.com', '', NULL, '客户', b'1', 0.000000, 0.000000, 0.000000, 0.000000, NULL, '', '182021551242', '', '', '', '', NULL, 63, '0');
INSERT INTO `jsh_supplier` VALUES (74, '苏州科达科技', '王五', '02146376829', '18202155142@163.com', '', NULL, '供应商', b'1', 0.000000, 0.000000, 3300.000000, NULL, NULL, '787233', '18202155142', '', '', '', '', NULL, 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_system_config
-- ----------------------------
DROP TABLE IF EXISTS `jsh_system_config`;
CREATE TABLE `jsh_system_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `company_name` varchar(50) DEFAULT NULL COMMENT '公司名称',
  `company_contacts` varchar(20) DEFAULT NULL COMMENT '公司联系人',
  `company_address` varchar(50) DEFAULT NULL COMMENT '公司地址',
  `company_tel` varchar(20) DEFAULT NULL COMMENT '公司电话',
  `company_fax` varchar(20) DEFAULT NULL COMMENT '公司传真',
  `company_post_code` varchar(20) DEFAULT NULL COMMENT '公司邮编',
  `depot_flag` varchar(1) DEFAULT '0' COMMENT '仓库启用标记，0未启用，1启用',
  `customer_flag` varchar(1) DEFAULT '0' COMMENT '客户启用标记，0未启用，1启用',
  `minus_stock_flag` varchar(1) DEFAULT '0' COMMENT '负库存启用标记，0未启用，1启用',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统参数';

-- ----------------------------
-- Records of jsh_system_config
-- ----------------------------
BEGIN;
INSERT INTO `jsh_system_config` VALUES (9, '公司1', '小军', '地址1', '12313', '1233', '4231', '0', '0', '1', 63, '1');
INSERT INTO `jsh_system_config` VALUES (10, '太仓市中仓钨业科技有限公司', '刘成凡', '太仓市', '1820155142', '2030012', '702303', '1', '1', '1', 63, '0');
COMMIT;

-- ----------------------------
-- Table structure for jsh_tenant
-- ----------------------------
DROP TABLE IF EXISTS `jsh_tenant`;
CREATE TABLE `jsh_tenant` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '用户id',
  `login_name` varchar(255) DEFAULT NULL COMMENT '登录名',
  `user_num_limit` int(11) DEFAULT NULL COMMENT '用户数量限制',
  `bills_num_limit` int(11) DEFAULT NULL COMMENT '单据数量限制',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='租户';

-- ----------------------------
-- Records of jsh_tenant
-- ----------------------------
BEGIN;
INSERT INTO `jsh_tenant` VALUES (13, 63, 'zcwy', 20, 2000, NULL);
INSERT INTO `jsh_tenant` VALUES (22, 137, '18202155142', 1000000, 100000000, '2020-10-29 08:55:18');
INSERT INTO `jsh_tenant` VALUES (23, 139, '18279392892', 1000000, 100000000, '2020-10-29 09:13:54');
INSERT INTO `jsh_tenant` VALUES (24, 138, '18279392892', 1000000, 100000000, '2020-10-29 09:13:58');
INSERT INTO `jsh_tenant` VALUES (25, 141, '18239283922', 1000000, 100000000, '2020-10-29 09:49:01');
COMMIT;

-- ----------------------------
-- Table structure for jsh_unit
-- ----------------------------
DROP TABLE IF EXISTS `jsh_unit`;
CREATE TABLE `jsh_unit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称，支持多单位',
  `basic_unit` varchar(50) DEFAULT NULL COMMENT '基础单位',
  `other_unit` varchar(50) DEFAULT NULL COMMENT '副单位',
  `ratio` int(11) DEFAULT NULL COMMENT '比例',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='多单位表';

-- ----------------------------
-- Records of jsh_unit
-- ----------------------------
BEGIN;
INSERT INTO `jsh_unit` VALUES (15, '个,箱(1:12)', '个', '箱', 12, 63, '0');
INSERT INTO `jsh_unit` VALUES (16, '个,台(1:10)', '个', '台', 10, 63, '1');
INSERT INTO `jsh_unit` VALUES (17, '个,只(1:12)', '个', '只', 12, 63, '1');
COMMIT;

-- ----------------------------
-- Table structure for jsh_user
-- ----------------------------
DROP TABLE IF EXISTS `jsh_user`;
CREATE TABLE `jsh_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(255) NOT NULL COMMENT '用户姓名--例如张三',
  `login_name` varchar(255) NOT NULL COMMENT '登录用户名',
  `password` varchar(50) DEFAULT NULL COMMENT '登陆密码',
  `position` varchar(200) DEFAULT NULL COMMENT '职位',
  `department` varchar(255) DEFAULT NULL COMMENT '所属部门',
  `email` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `phonenum` varchar(100) DEFAULT NULL COMMENT '手机号码',
  `ismanager` tinyint(4) NOT NULL DEFAULT '1' COMMENT '是否为管理者 0==管理者 1==员工',
  `isystem` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否系统自带数据 ',
  `Status` tinyint(4) DEFAULT '0' COMMENT '状态，0：正常，1：删除，2封禁',
  `description` varchar(500) DEFAULT NULL COMMENT '用户描述信息',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of jsh_user
-- ----------------------------
BEGIN;
INSERT INTO `jsh_user` VALUES (63, '高啟骏', 'gaoqijun', 'e10adc3949ba59abbe56e057f20f883e', '管理员', NULL, '18202155142@163.com', '18202155142', 1, 1, 0, '管理员', NULL, 63);
INSERT INTO `jsh_user` VALUES (120, '管理员', 'admin', 'e10adc3949ba59abbe56e057f20f883e', NULL, NULL, NULL, NULL, 1, 0, 0, NULL, NULL, NULL);
INSERT INTO `jsh_user` VALUES (142, '刘成凡', 'liuchengfan', 'e10adc3949ba59abbe56e057f20f883e', '总经理', NULL, '18708928392@163.com', '18708928392', 1, 0, 0, '总经理', NULL, 63);
COMMIT;

-- ----------------------------
-- Table structure for jsh_user_business
-- ----------------------------
DROP TABLE IF EXISTS `jsh_user_business`;
CREATE TABLE `jsh_user_business` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类别',
  `key_id` varchar(50) DEFAULT NULL COMMENT '主id',
  `value` varchar(10000) DEFAULT NULL COMMENT '值',
  `btn_str` varchar(2000) DEFAULT NULL COMMENT '按钮权限',
  `delete_flag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8 COMMENT='用户/角色/模块关系表';

-- ----------------------------
-- Records of jsh_user_business
-- ----------------------------
BEGIN;
INSERT INTO `jsh_user_business` VALUES (5, 'RoleFunctions', '4', '[241][33][199][254][242][41][200][201][202][40][250][251][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][23][252][25][217][26][248][31][13][14][243][15][234][16][236][245]', '[{\"funId\":\"13\",\"btnStr\":\"1\"},{\"funId\":\"14\",\"btnStr\":\"1\"},{\"funId\":\"243\",\"btnStr\":\"1\"},{\"funId\":\"234\",\"btnStr\":\"1\"},{\"funId\":\"16\",\"btnStr\":\"1\"},{\"funId\":\"236\",\"btnStr\":\"1\"},{\"funId\":\"245\",\"btnStr\":\"1\"},{\"funId\":\"254\",\"btnStr\":\"2,1\"},{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"252\",\"btnStr\":\"2\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"248\",\"btnStr\":\"1\"},{\"funId\":\"31\",\"btnStr\":\"1\"},{\"funId\":\"250\",\"btnStr\":\"1\"},{\"funId\":\"251\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"},{\"funId\":\"201\",\"btnStr\":\"1,2\"},{\"funId\":\"202\",\"btnStr\":\"1,2\"},{\"funId\":\"40\",\"btnStr\":\"1,2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (6, 'RoleFunctions', '5', '[22][23][25][26][194][195][31][33][200][201][41][199][202]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (7, 'RoleFunctions', '6', '[22][23][220][240][25][217][218][26][194][195][31][59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212]', '[{\"funId\":\"33\",\"btnStr\":\"4\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (9, 'RoleFunctions', '7', '[168][13][12][16][14][15][189][18][19][132]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (10, 'RoleFunctions', '8', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (11, 'RoleFunctions', '9', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][188]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (12, 'UserRole', '1', '[5]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (13, 'UserRole', '2', '[6][7]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (14, 'UserDepot', '2', '[1][2][6][7]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (15, 'UserDepot', '1', '[1][2][5][6][7][10][12][14][15][17]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (16, 'UserRole', '63', '[26]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (18, 'UserDepot', '63', '[14][15]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (19, 'UserDepot', '5', '[6][45][46][50]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (20, 'UserRole', '5', '[5]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (21, 'UserRole', '64', '[13]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (22, 'UserDepot', '64', '[1]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (23, 'UserRole', '65', '[5]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (24, 'UserDepot', '65', '[1]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (25, 'UserCustomer', '64', '[5][2]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (26, 'UserCustomer', '65', '[6]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (27, 'UserCustomer', '63', '[58]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (28, 'UserDepot', '96', '[7]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (29, 'UserRole', '96', '[6]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (30, 'UserRole', '113', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (32, 'RoleFunctions', '10', '[210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][246][22][23][220][240][25][217][218][26][194][195][31][13][243][14][15][234][249][250][248][251]', '[{\"funId\":\"13\",\"btnStr\":\"1\"},{\"funId\":\"243\",\"btnStr\":\"1\"},{\"funId\":\"14\",\"btnStr\":\"1\"},{\"funId\":\"234\",\"btnStr\":\"1\"},{\"funId\":\"22\",\"btnStr\":\"1\"},{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"220\",\"btnStr\":\"1\"},{\"funId\":\"240\",\"btnStr\":\"1\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"194\",\"btnStr\":\"1\"},{\"funId\":\"195\",\"btnStr\":\"1\"},{\"funId\":\"31\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"210\",\"btnStr\":\"1,2\"},{\"funId\":\"211\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"},{\"funId\":\"201\",\"btnStr\":\"1,2\"},{\"funId\":\"202\",\"btnStr\":\"1,2\"},{\"funId\":\"40\",\"btnStr\":\"1,2\"},{\"funId\":\"232\",\"btnStr\":\"1,2\"},{\"funId\":\"233\",\"btnStr\":\"1,2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (34, 'UserRole', '115', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (35, 'UserRole', '117', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (36, 'UserDepot', '117', '[8][9]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (37, 'UserCustomer', '117', '[52]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (38, 'UserRole', '120', '[4]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (39, 'UserDepot', '120', '[7][8][9][10][11][12][2][1][3]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (40, 'UserCustomer', '120', '[52][48][6][5][2]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (41, 'RoleFunctions', '12', '', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (48, 'RoleFunctions', '13', '[59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (51, 'UserRole', '74', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (52, 'UserDepot', '121', '[13]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (54, 'UserDepot', '115', '[13]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (56, 'UserCustomer', '115', '[56]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (57, 'UserCustomer', '121', '[56]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (58, 'UserRole', '121', '[15]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (59, 'UserRole', '123', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (60, 'UserRole', '124', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (61, 'UserRole', '125', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (62, 'UserRole', '126', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (63, 'UserRole', '127', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (64, 'UserRole', '128', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (65, 'UserRole', '129', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (66, 'UserRole', '130', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (67, 'UserRole', '131', '[17]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (68, 'RoleFunctions', '16', '[210]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (69, 'RoleFunctions', '17', '[210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212]', '[{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"210\",\"btnStr\":\"1,2\"},{\"funId\":\"211\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"},{\"funId\":\"201\",\"btnStr\":\"1,2\"},{\"funId\":\"202\",\"btnStr\":\"1,2\"},{\"funId\":\"40\",\"btnStr\":\"1,2\"},{\"funId\":\"232\",\"btnStr\":\"1,2\"},{\"funId\":\"233\",\"btnStr\":\"1,2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (70, 'UserRole', '132', '[23]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (71, 'UserRole', '133', '[25]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (72, 'UserRole', '134', '[26]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (73, 'UserRole', '135', '[21]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (74, 'UserRole', '136', '[27]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (75, 'RoleFunctions', '19', '[241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][22][23][220][240][25][217][26][248][194][195][31][13][14][243][15][234][16][236][245]', '[{\"funId\":\"13\",\"btnStr\":\"1\"},{\"funId\":\"14\",\"btnStr\":\"1\"},{\"funId\":\"243\",\"btnStr\":\"1\"},{\"funId\":\"234\",\"btnStr\":\"1\"},{\"funId\":\"16\",\"btnStr\":\"1\"},{\"funId\":\"236\",\"btnStr\":\"1\"},{\"funId\":\"245\",\"btnStr\":\"1\"},{\"funId\":\"22\",\"btnStr\":\"1\"},{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"220\",\"btnStr\":\"1\"},{\"funId\":\"240\",\"btnStr\":\"1\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"248\",\"btnStr\":\"1\"},{\"funId\":\"194\",\"btnStr\":\"1\"},{\"funId\":\"195\",\"btnStr\":\"1\"},{\"funId\":\"31\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (76, 'RoleFunctions', '21', '[59][207][208][209][226][227][228][229][235][237][244]', '', '0');
INSERT INTO `jsh_user_business` VALUES (77, 'RoleFunctions', '23', '[210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][246][22][23][220][240][25][217][218][26][194][195][31][13][243][14][15][234][249][250][248][251]', '[{\"funId\":\"13\",\"btnStr\":\"1\"},{\"funId\":\"243\",\"btnStr\":\"1\"},{\"funId\":\"14\",\"btnStr\":\"1\"},{\"funId\":\"234\",\"btnStr\":\"1\"},{\"funId\":\"22\",\"btnStr\":\"1\"},{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"220\",\"btnStr\":\"1\"},{\"funId\":\"240\",\"btnStr\":\"1\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"194\",\"btnStr\":\"1\"},{\"funId\":\"195\",\"btnStr\":\"1\"},{\"funId\":\"31\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"210\",\"btnStr\":\"1,2\"},{\"funId\":\"211\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"},{\"funId\":\"201\",\"btnStr\":\"1,2\"},{\"funId\":\"202\",\"btnStr\":\"1,2\"},{\"funId\":\"40\",\"btnStr\":\"1,2\"},{\"funId\":\"232\",\"btnStr\":\"1,2\"},{\"funId\":\"233\",\"btnStr\":\"1,2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (78, 'UserRole', '137', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (79, 'UserRole', '139', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (80, 'UserRole', '138', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (81, 'RoleFunctions', '28', '[250][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][22][23][220][240][25][217][26][248][194][195][31]', '', '0');
INSERT INTO `jsh_user_business` VALUES (82, 'UserRole', '141', '[10]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (84, 'UserRole', '142', '[21]', NULL, '0');
INSERT INTO `jsh_user_business` VALUES (85, 'RoleFunctions', '22', '[197][203][204][205][206][212]', '[{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (86, 'RoleFunctions', '24', '[242][25][217][26]', '[{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (87, 'RoleFunctions', '25', '[241][33][199][23][252][253][25][217][26]', '[{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"252\",\"btnStr\":\"2\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"253\",\"btnStr\":\"2\"}]', '0');
INSERT INTO `jsh_user_business` VALUES (88, 'RoleFunctions', '26', '[241][33][199][242][41][200][254][201][202][40][250][251][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][23][252][253][25][217][26][248][31][13][14][243][15][234][16][236][245]', '[{\"funId\":\"13\",\"btnStr\":\"1\"},{\"funId\":\"14\",\"btnStr\":\"1\"},{\"funId\":\"243\",\"btnStr\":\"1\"},{\"funId\":\"234\",\"btnStr\":\"1\"},{\"funId\":\"16\",\"btnStr\":\"1\"},{\"funId\":\"236\",\"btnStr\":\"1\"},{\"funId\":\"245\",\"btnStr\":\"1\"},{\"funId\":\"23\",\"btnStr\":\"1\"},{\"funId\":\"252\",\"btnStr\":\"2\"},{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"26\",\"btnStr\":\"1\"},{\"funId\":\"248\",\"btnStr\":\"1\"},{\"funId\":\"31\",\"btnStr\":\"1\"},{\"funId\":\"250\",\"btnStr\":\"1\"},{\"funId\":\"251\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"1,2\"},{\"funId\":\"33\",\"btnStr\":\"1,2\"},{\"funId\":\"199\",\"btnStr\":\"1,2\"},{\"funId\":\"242\",\"btnStr\":\"1,2\"},{\"funId\":\"41\",\"btnStr\":\"1,2\"},{\"funId\":\"200\",\"btnStr\":\"1,2\"},{\"funId\":\"197\",\"btnStr\":\"1\"},{\"funId\":\"203\",\"btnStr\":\"1\"},{\"funId\":\"204\",\"btnStr\":\"1\"},{\"funId\":\"205\",\"btnStr\":\"1\"},{\"funId\":\"206\",\"btnStr\":\"1\"},{\"funId\":\"212\",\"btnStr\":\"1\"},{\"funId\":\"253\",\"btnStr\":\"2\"},{\"funId\":\"201\",\"btnStr\":\"1,2\"},{\"funId\":\"202\",\"btnStr\":\"1,2\"},{\"funId\":\"40\",\"btnStr\":\"1,2\"},{\"funId\":\"254\",\"btnStr\":\"2\"}]', '0');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
